JDBC连数据库登录部分

来源：互联网发布：软件迭代记录编辑：程序博客网时间：2024/05/16 01:32

<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%@ page import="java.sql.*" %>

<html>
<body>
<% String driverName="com.mysql.jdbc.Driver";
String userName="root";
String userPwd="123";
String dbName="login";
String url1="jdbc:mysql://localhost:3306/"+dbName;
String url2="?user="+userName+"&password="+userPwd;
String url3="&useUnicode=true&characterEncoding=UTF-8";
String url=url1+url2+url3;
Class.forName(driverName);
Connection conn=DriverManager.getConnection(url);
Statement stmt=conn.createStatement();

%>


<%
String name1=request.getParameter("name");
String passwd=request.getParameter("pwd");
String sql="select * from logininfo where userName='"+name1+"' and userPwd='"+passwd+"'";
ResultSet rs=stmt.executeQuery(sql);
try {
if (rs.next())
{
request.getRequestDispatcher("success.jsp").forward(request, response);
}
else
{
response.sendRedirect("fail.jsp");
}
}catch(SQLException e){
e.printStackTrace();
}

%>


</body>
</html>

阅读全文

0 0