81,095
社区成员
发帖
与我相关
我的任务
分享
<%@ page language="java" import="java.util.*" pageEncoding="GBK"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">
<title>My JSP 'index.jsp' starting page</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
</head>
<body>
<form method="get" action="check.jsp">
<table>
<tr><td>用户名:<input type="text" name="username" value=""></td></tr>
<tr><td>密码:<input type="password" name="password" value=""></td></tr>
<tr><td><input type="submit" value="提交" ></td>
<td valign="top"><br></td><td valign="top"><br></td><td valign="top"><br></td><td valign="top"><br></td><td><input type="reset" value="取消" ></td></tr>
</table>
</form>
</body>
</html>
package yours;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class JDBConnection{
private final String dbDriver="com.mysql.jdbc.Driver";
private final String url="jdbc:mysql://localhost:3306/char1_2";
private final String userName="root";
private final String password="1991016";
private Connection con;
public JDBConnection()
{
try{
Class.forName(dbDriver).newInstance();
}catch (Exception e)
{
System.out.println("未能成功加载驱动!");
}
}
public boolean createConnection()
{
try{
con=DriverManager.getConnection(url,userName,password);
con.setAutoCommit(true);
}catch(SQLException e)
{
return false;
}
return true;
}
public ResultSet executeQuery(String sql)
{
ResultSet rs;
try
{
if(con==null)
createConnection();
Statement stmt =con.createStatement();
rs=stmt.executeQuery(sql);
}catch(Exception e)
{
return null;
}
return rs;
}
public void closeConnection()
{
if(con!=null)
{
try{
con.close();
}catch(SQLException e)
{
}
}
}
}
<%@ page language="java" import="java.util.*" pageEncoding="GBK"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">
<title>My JSP 'check.jsp' starting page</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
-->
</head>
<body>
<%@ page import="java.sql.*" %>
<jsp:useBean id="mysql" scope="page" class="yours.JDBConnection"/>
<%
String username=new String(request.getParameter("username"));//接收传递过来的用户名
String password=new String(request.getParameter("password"));//接收传递过来的密码
String sql="select * from table1";
ResultSet rs=null;
mysql.createConnection();
rs=mysql.executeQuery(sql);
String usr1=null;//获取数据库中的用户名
String passwd1=null;//获取用户名中的密码
boolean flag=false;
while(rs.next()){
usr1=rs.getString("username");
passwd1=rs.getString("password");
if(usr1==username&&passwd1==password)
{
out.println("欢迎你,用户:"+usr1.toString());
flag=true;
break;//找到记录就跳出循环//
}
}
if(flag)
out.println("没找到你的用户名,"+username.toString()+"没有注册!");
rs.close();
mysql.closeConnection();
%>
</body>
</html>