<%@ page language="java" contentType="text/html; charset=GB2312"
pageEncoding="GB2312"%>
<%@page import= "java.sql.*" %>
<html>
<head>
<title>Login</title>
</head>
<body>
<form name="form1" method="post" action="test.jsp">
用u25143 名<input type="text" name="userlg"><br>
密u30721 :<input type="password" name="pwdlg"><br><br>
<input type="submit" name="Submit" value="login">    <input type="reset" name="Reset" value="reset">
</form>
<%
Statement stmt=null;
ResultSet rs=null;
Connection conn=null;
String sql=null;
String USERS=request.getParameter("userlg"); //输入的用户名
String PWD=request.getParameter("pwdlg"); //输入的密码
try
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=UpLoad";
conn=DriverManager.getConnection(url,"guocai","123456789");
stmt=conn.createStatement();
sql="select * from register where users='"+USERS+"' and pwd='"+PWD+"'";
rs=stmt.executeQuery(sql);
if(rs.next())
本内容试读结束，登录后可阅读更多
下载后可阅读完整内容，剩余1页未读，立即下载
