<body>
<form action="servlet/Login" method="post">
ç¨æ·å:<input type="text" name="username"> <br/>
å¯ ç :<input type="keyword" name="keyword"><br/>
å¦ å·:<input type="num" name="num"><br/>
<input type="submit" value="注å">
</form>
</body>
ä¸é¢æ¯è·å表åä¿¡æ¯ï¼å¹¶ä¿åå°æ°æ®åºä¸çservletï¼æ³¨æè·åä¿¡æ¯æ¶ååè¦åjspæ交çä¿¡æ¯ä¸è´ï¼
response.setContentType("text/html;charset=UTF-8");
//è·åè¾å ¥ä¿¡æ¯
String member = request.getParameter("username");
String keyword = request.getParameter("keyword");
String num = request.getParameter("num");
//è¿æ¥æ°æ®åº
String url = "jdbc:mysql://localhost:3306/thecheck";
String user="root";
String password = "19960104";
try {
Class.forName("com.mysql.jdbc.Driver");
try {
java.sql.Connection conn = DriverManager.getConnection(url, user, password);
java.sql.Statement st = conn.createStatement();
String sql = "insert into student values("+"'"+member+"',"+"'"+keyword+"',"+"'"+num+"',"+"0)";
//System.out.println(sql);
st.executeUpdate(sql);
} catch (SQLException e) {
e.printStackTrace();
}
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
}
å ¶ä¸è¿è¦æ³¨æçæ¯åçè¾å ¥è¯å¥è¦åæ°æ®åºä¸çsqlè¯å¥å¯¹åºï¼å¦åä¹ä¼åºç°é误ã
<form action="servlet/Login" method="post">
ç¨æ·å:<input type="text" name="username"> <br/>
å¯ ç :<input type="keyword" name="keyword"><br/>
å¦ å·:<input type="num" name="num"><br/>
<input type="submit" value="注å">
</form>
</body>
ä¸é¢æ¯è·å表åä¿¡æ¯ï¼å¹¶ä¿åå°æ°æ®åºä¸çservletï¼æ³¨æè·åä¿¡æ¯æ¶ååè¦åjspæ交çä¿¡æ¯ä¸è´ï¼
response.setContentType("text/html;charset=UTF-8");
//è·åè¾å ¥ä¿¡æ¯
String member = request.getParameter("username");
String keyword = request.getParameter("keyword");
String num = request.getParameter("num");
//è¿æ¥æ°æ®åº
String url = "jdbc:mysql://localhost:3306/thecheck";
String user="root";
String password = "19960104";
try {
Class.forName("com.mysql.jdbc.Driver");
try {
java.sql.Connection conn = DriverManager.getConnection(url, user, password);
java.sql.Statement st = conn.createStatement();
String sql = "insert into student values("+"'"+member+"',"+"'"+keyword+"',"+"'"+num+"',"+"0)";
//System.out.println(sql);
st.executeUpdate(sql);
} catch (SQLException e) {
e.printStackTrace();
}
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
}
å ¶ä¸è¿è¦æ³¨æçæ¯åçè¾å ¥è¯å¥è¦åæ°æ®åºä¸çsqlè¯å¥å¯¹åºï¼å¦åä¹ä¼åºç°é误ã
温馨提示：答案为网友推荐，仅供参考
相似回答