JSP注册页面（连接并插入数据库）

来源：互联网发布：孤岛惊魂3低设置优化编辑：程序博客网时间：2024/06/05 17:13

<%@ page language="java" import="java.sql.*" pageEncoding="UTF-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<html>
<body>
<%
request.setCharacterEncoding("utf-8");
String users=request.getParameter("username");
String pass=request.getParameter("pwd");
%>
<%
String driver = "com.mysql.jdbc.Driver";
String url = "jdbc:mysql://127.0.0.1:3306/users";
String use = "root";
String password = "5201314";
Class.forName(driver);
Connection conn= DriverManager.getConnection(url,use,password);
PreparedStatement sql =conn.prepareStatement("insert into zm(id,pass)values(?,?)");
sql.setString(1,users);
sql.setString(2,pass);
int rtn=sql.executeUpdate();
sql.close();
conn.close();
%>
<%
if(rtn==1){%><jsp:forward page="enroll_success.jsp"/><%}
else{%><jsp:forward page="enroll_fail.jsp"/><%}
%>
</body>
</html>

阅读全文

0 0