您所在位置：主题：急。。jsp连接DB2数据库出错，请高手帮忙，谢谢了
smoker11
[专家分：0] 发布于 2006-09-20 11:24:00
<%@ page contentType="text/html"%>
<%@ page import="java.sql.*"%>
<%@ page import="java.util.*" %>
<%@ page import="java.io.*" %>
<%@ page language="java" pageEncoding="gbk" errorPage=" "%>
<html>
<head>
<title>用户登录界面</title>
</head>
<body>
<center><font size="5" face="楷体">DB2用户登录</font></center>
<hr>
<%
if (request.getParameter("name")!=null)
{ String name=request.getParameter("name");
String password=request.getParameter("password");
//定义数据库对象
String url="jdbc:db2://127.0.0.1/mydb";//此格式为jdbc:子协议：子名称，其中mydb是数据库名
String user="db2admin";//数据库连接者ID
String dbpass="db2admin";//数据库连接者密码
java.sql.Connection sqlConn;
java.sql.Statement sqlStmt;
java.sql.ResultSet sqlRst;
try
{ //登记JDBC驱动对象
Class.forName("COM.ibm.db2.jdbc.net.DB2Driver").newInstance();
//连接数据库
sqlConn= DriverManager.getConnection(url,user,dbpass);
//创建语句对象
sqlStmt=sqlConn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
//执行Sql语句
String sql="select count(*) from mytable where name='"+name+"' and pass='"+password+"'";
sqlRst=sqlStmt.executeQuery(sql);
sqlRst.next();
if(sqlRst.getInt(1)>0)
{ out.println("欢迎登录: "+name);
out.println("<form name='frmquery' method='post' action='quee.jsp'>");
out.println("<p>根据姓名查询：<input type='text' name='name'> <br><br>");
out.println(" <p> <input type='submit' name='Submit' value='查询'></p></form><p></p> <p>");
}
else
{
out.println("用户名或密码错误，请重新登录");
out.println("<form name='frmlogon' method='post' action='logon.jsp'>");
out.println("<p>输入用户名：<input type='text' name='name'> <br><br>");
out.println("输入密码： <input type='password' name='password'></p>");
out.println(" <p> <input type='submit' name='Submit' value='提交'></p></form><p></p> <p>");
}
sqlStmt.close();
sqlConn.close();
}
catch (Exception E){
out.println("数据数据访问出现问题，请稍后再试");}
}
else
{
out.println("用户名和密码不能为空:");
out.println("<form name='frmlogon' method='post' action='logon.jsp'>");
out.println("<p>输入用户名：<input type='text' name='name'> <br><br>");
out.println("输入密码： <input type='password' name='password'></p>");
out.println(" <p> <input type='submit' name='Submit' value='提交'></p></form><p></p> <p>");
}
%>
</p>
</body>
</html>
<%@ page import="java.sql.*"%>
<%@ page import="java.util.*" %>
<%@ page import="java.io.*" %>
<%@ page language="java" pageEncoding="gbk" errorPage=" "%>
<html>
<head>
<title>用户登录界面</title>
</head>
<body>
<center><font size="5" face="楷体">DB2用户登录</font></center>
<hr>
<%
if (request.getParameter("name")!=null)
{ String name=request.getParameter("name");
String password=request.getParameter("password");
//定义数据库对象
String url="jdbc:db2://127.0.0.1/mydb";//此格式为jdbc:子协议：子名称，其中mydb是数据库名
String user="db2admin";//数据库连接者ID
String dbpass="db2admin";//数据库连接者密码
java.sql.Connection sqlConn;
java.sql.Statement sqlStmt;
java.sql.ResultSet sqlRst;
try
{ //登记JDBC驱动对象
Class.forName("COM.ibm.db2.jdbc.net.DB2Driver").newInstance();
//连接数据库
sqlConn= DriverManager.getConnection(url,user,dbpass);
//创建语句对象
sqlStmt=sqlConn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
//执行Sql语句
String sql="select count(*) from mytable where name='"+name+"' and pass='"+password+"'";
sqlRst=sqlStmt.executeQuery(sql);
sqlRst.next();
if(sqlRst.getInt(1)>0)
{ out.println("欢迎登录: "+name);
out.println("<form name='frmquery' method='post' action='quee.jsp'>");
out.println("<p>根据姓名查询：<input type='text' name='name'> <br><br>");
out.println(" <p> <input type='submit' name='Submit' value='查询'></p></form><p></p> <p>");
}
else
{
out.println("用户名或密码错误，请重新登录");
out.println("<form name='frmlogon' method='post' action='logon.jsp'>");
out.println("<p>输入用户名：<input type='text' name='name'> <br><br>");
out.println("输入密码： <input type='password' name='password'></p>");
out.println(" <p> <input type='submit' name='Submit' value='提交'></p></form><p></p> <p>");
}
sqlStmt.close();
sqlConn.close();
}
catch (Exception E){
out.println("数据数据访问出现问题，请稍后再试");}
}
else
{
out.println("用户名和密码不能为空:");
out.println("<form name='frmlogon' method='post' action='logon.jsp'>");
out.println("<p>输入用户名：<input type='text' name='name'> <br><br>");
out.println("输入密码： <input type='password' name='password'></p>");
out.println(" <p> <input type='submit' name='Submit' value='提交'></p></form><p></p> <p>");
}
%>
</p>
</body>
</html>