📄 insertdata.jsp
字号:
<%@ page language="java" contentType="text/html; charset=utf-8"%>
<%@ page import="java.sql.*, ajax.db.DBUtils"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>My JSP 'insertdata.jsp' starting page</title>
</head>
<body>
<%
request.setCharacterEncoding("UTF-8");
String selA = request.getParameter("selA");
String selB = request.getParameter("selB");
String selC = request.getParameter("selC");
String uname = request.getParameter("uname");
Connection conn = null;
PreparedStatement pstmt=null;
ResultSet rs=null;
String sql = "insert into userInfo values(?,?,?,?)";
try
{
conn = DBUtils.getConnection();
pstmt = conn.prepareStatement(sql);
pstmt.setString(1,selA);
pstmt.setString(2,selB);
pstmt.setString(3,selC);
pstmt.setString(4,uname);
pstmt.executeUpdate();
out.println("插入成功");
}
catch(SQLException se)
{
System.out.println(se.getMessage());
}
finally
{
DBUtils.close(rs);
DBUtils.close(pstmt);
DBUtils.close(conn);
}
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -