📄 insert.jsp
字号:
<%@ page contentType="text/html;charset=GBK"%>
<%@ page import="java.sql.*"%>
<html>
<body>
<%
//request.setCharacterEncoding("GBK");
String USERNAME=new String(request.getParameter("username").getBytes("8859_1"), "GBK");
System.out.println(USERNAME);
String PASSWORD=new String(request.getParameter("pwd").getBytes("8859_1"), "GBK");
//加载驱动
Class.forName("com.mysql.jdbc.Driver").newInstance();
//创建数据库连接
//Connection conn= DriverManager.getConnection("jdbc:mysql://localhost:3306/test?user=root&password=1234&useUnicode=true&characterEncoding=gbk");
String dbUrl ="jdbc:mysql://localhost:3306/test";
String dbUser="root";
String dbPwd="1234";
Connection conn= DriverManager.getConnection(dbUrl,dbUser,dbPwd);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="INSERT INTO userlist(userName,userPwd) VALUES('"+USERNAME+"','"+PASSWORD+"')";
//执行插入数据的操作
stmt.executeUpdate(sql);
out.println("您已成功注册!!");
stmt.close();
conn.close();
%>
</body>
</html> ⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -