How insert data to MySQL for using JSP code?
I have 1st time do JSP code, hope somebody can help me solve my problem..thk!
My code are below:
JSP file:input.jsp
<%@ page contentType="text/html" %>
<%@ page language="java" contentType="text/html" import="java.sql.*" %>
<%@ page import="java.io.*" %>
<%@ page import="java.util.*" %>
<html>
<head>
<title> User Info Entry Form</title>
</head>
<body>
<%
// 1. load the mysql jdbcc driver
Class.forName("com.mysql.jdbc.Driver");
// 2. open a connection to the "project" database
Connection Conn = DriverManager.getConnection
("jdbc:mysql://localhost/project?user=root&password=root");
// 3. Create a statement object for sending the SQL queries
Statement Stmt = Conn.createStatement();
// 4. place query results in a ResultSet object
String courseworkid= request.getParameter("coursework_id");
String unitcode = request.getParameter("unit_code");
String description1 = request.getParameter("description");
String actualmark= request.getParameter("actual_mark");
String weight1 = request.getParameter("weight");
PreparedStatement ps=Conn.prepareStatement("INSERT INTO coursework VALUES (?,?,?,?,?)");
ps.setString(1,courseworkid );
ps.setString(2,unitcode );
ps.setString(3,description1 );
ps.setInt(4,actualmark);
ps.setInt(5,weight1);
ps.executeUpdate();
ps.clearParameters();
// 5. Clean up all objects
Conn.close();
Stmt.close();
ps.close();
}catch(Exception e)
{
out.println(e);
}
%>
</body>
</html>
Message was edited by:
mike_yong
Message was edited by:
mike_yong
