<%@ page contentType="text/html; charset=GB2312" %>
<%@ page import="java.sql.*" %>
<html>
<head><title>用户登录</title>
</head>
<body><center>
<% request.setCharacterEncoding("utf-8");
String s_username=request.getParameter("username");
if(s_username==null){
s_username="";
}
String s_password=request.getParameter("password");
if(s_password==null){
s_password="";
}
%>
<font size=4 color=blue>用户登陆</font><hr>
<%
String sql;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn=DriverManager.getConnection("jdbc:odbc:myselflk","sa","");
Statement stmt=conn.createStatement();
try{
sql="select username from web1.dbo.myself where password='"+s_password+"'";stmt.executeUpdate(sql);
ResultSet rs; //建立ResultSet(结果集)对象
rs=stmt.executeQuery("select username from web1.dbo.myself where password='"+s_password+"'");
//执行SQL语句
%>
<table border=3>
<tr bgcolor=silver><b>
<td><center>您好!</td><td><center>用户名</td><td><center>登陆成功!</td>
</tr>
<%
//利用while循环将数据表中的记录列出 while (rs.next()){
%>
<tr>
<td width="165"><a class="navText"><center>欢迎光临!</a></td>
<td><font size=2><%= rs.getString("username") %></font></td>
<td width="165"><a href="main.html" class="navText"><center>进入主页>></a></td>
</tr>
<%
} rs.close(); //关闭ResultSet对象
}
catch(Exception e){
out.println(e.getMessage());
}
stmt.close(); //关闭Statement对象
conn.close(); //关闭Connection对象
%>
</table></center>
<p></p><p></p>
<tr>
<td width="165"><a href="enter.html" class="navText"><center><<重新登录</a></td>
</tr>
</body></html>
<%@ page import="java.sql.*" %>
<html>
<head><title>用户登录</title>
</head>
<body><center>
<% request.setCharacterEncoding("utf-8");
String s_username=request.getParameter("username");
if(s_username==null){
s_username="";
}
String s_password=request.getParameter("password");
if(s_password==null){
s_password="";
}
%>
<font size=4 color=blue>用户登陆</font><hr>
<%
String sql;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn=DriverManager.getConnection("jdbc:odbc:myselflk","sa","");
Statement stmt=conn.createStatement();
try{
sql="select username from web1.dbo.myself where password='"+s_password+"'";stmt.executeUpdate(sql);
ResultSet rs; //建立ResultSet(结果集)对象
rs=stmt.executeQuery("select username from web1.dbo.myself where password='"+s_password+"'");
//执行SQL语句
%>
<table border=3>
<tr bgcolor=silver><b>
<td><center>您好!</td><td><center>用户名</td><td><center>登陆成功!</td>
</tr>
<%
//利用while循环将数据表中的记录列出 while (rs.next()){
%>
<tr>
<td width="165"><a class="navText"><center>欢迎光临!</a></td>
<td><font size=2><%= rs.getString("username") %></font></td>
<td width="165"><a href="main.html" class="navText"><center>进入主页>></a></td>
</tr>
<%
} rs.close(); //关闭ResultSet对象
}
catch(Exception e){
out.println(e.getMessage());
}
stmt.close(); //关闭Statement对象
conn.close(); //关闭Connection对象
%>
</table></center>
<p></p><p></p>
<tr>
<td width="165"><a href="enter.html" class="navText"><center><<重新登录</a></td>
</tr>
</body></html>
解决方案 »
- java学习遇到了 很大的麻烦!跪求高手指点迷津! 谁能给出java 学习的高校学习方法!
- 关于jcombobox的item选择事件的问题
- java 打包成jar后无法运行(在eclipse下可以运行)???
- 菜鸟我怎么装不了JMF啊!!知道的朋友帮我一下,多谢 !!
- 这个简单的问题要麻烦大家了,不好意思我是个java的菜鸟!,谢谢!
- 请帮我看看这个继承的例子。
- 散分!!!!散分!!!!散分!!!!散分!!!!散分!!!!散分!!!!
- 用Vector初始化JTable的问题!
- Error loading class classname : wrong name,
- 如何从数组中随机获取元素
- 一个JDBC的问题
- ArrayList集合构造函数的疑问
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn = DriverManager.getConnection("jdbc:odbc:myselflk",
"sa", "");
Statement stmt = conn.createStatement();
try {
sql = "select * from web1.dbo.myself where username='"
+ s_username + "'";
ResultSet rs = stmt.executeQuery(sql);
if(!rs.next()){
%>
<div>用户不存在</div>
<%
}
rs = stmt
.executeQuery("select username from web1.dbo.myself where password='"
+ s_password + "'");
//执行SQL语句
%>