<html>
<%@ page pageEncoding="UTF-8"%>
<%@ page import="java.sql.*" %>
<!DOCTYPE html>
<head>
<title>登录成功</title>
<meta http-equiv="Content-Type" content="textml; charset=UTF-8"></meta>
<script type="text/javascript">
function changeColor(obj,color){
obj.bgColor=color;
}
</script>
<style>
body{
background: url("../imgs/38.png") no-repeat center;
}
.big{
width: 800px;
height: 500px;
border: 8px solid #EEEEEE;
background-color: white;
margin: 15px auto auto;
}
.m{
padding-top: 150px;
margin:auto;
}
</style>
</head>
<body>
<%
//连接数据库
String driverName="com.microsoft.sqlserver.jdbc.SQLServerDriver";
String dbURL="jdbc:sqlserver://127.0.0.1:1433;DatabaseName=waijiao";
String userName="sa";
String pwd="1234567";
Class.forName(driverName);
Connection conn=DriverManager.getConnection(dbURL,userName,pwd);
String sql="update labfirst set pass_word=?,NOV=NOV+1 where name=?";
PreparedStatement stmp=conn.prepareStatement(sql);
request.setCharacterEncoding("UTF-8");
String name=request.getParameter("name");
String pass_word=request.getParameter("pass_word");
stmp.setString(1,pass_word);
stmp.setString(2,name);
int n=stmp.executeUpdate();
if(n==1){
out.println("登录成功!");
} else{
out.println("登录失败!");
}
if(stmp!=null){
stmp.close();
}
if(conn!=null){
conn.close();
}
%>
<%!//驱动路径
public static final String DBDRIVER = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
//数据库地址,;DataBaseName=CreditorAutomation可以不写
public static final String DBURL = "jdbc:sqlserver://127.0.0.1:1433;DatabaseName=waijiao";
//数据库登录用户名
public static final String DBUSER = "sa";
//数据库用户密码
public static final String DBPASSWORD = "1234567";
%>
<%//编写程序语句
//数据库连接
//数据库操作
PreparedStatement stmt = null;
//数据库查询结果集
ResultSet rs = null;
%>
<%
//加载驱动程序
Class.forName(DBDRIVER);
//连接数据库
conn = DriverManager.getConnection(DBURL, DBUSER, DBPASSWORD);
stmt = conn.prepareStatement("select * from labfirst");
rs = stmt.executeQuery();
%>
<div class="big">
<div class="m">
<table border="1" cellpadding="5" cleespacing="0" bgcolor="#20B2AA" width="400px" align="center">
<tr onmousemove="changeColor(this,'#7FFFD4')" onmouseout="changeColor(this,'#F2F2F2')">
<td><strong>name</strong></td>
<td><strong>pass_word</strong></td>
<td><strong>NOV</strong></td>
</tr>
<%
while(rs.next()){
String name1 = rs.getString(1);
String pass_wors1 = rs.getString(2);
String NOV = rs.getString(3);
%>
<tr onmousemove="changeColor(this,'#FFFFFF')" onmouseout="changeColor(this,'#F2F2F2')">
<td><%=name1%></td>
<td><%=pass_wors1%></td>
<td><%=NOV%></td>
</tr>
<%
}
%>
</table>
</div>
</div>
</body>
</html>