◎◎◎◎◎◎◎◎◎◎◎◎两个小问题◎◎◎◎◎◎◎

1.在login.java中加入 import (packagename).jdbcbean2.你可以先用 sun.jdbc.odbc.JdbcOdbcDriver 测试一下，看是否能够连通

解决方案 »

免费领取超大流量手机卡，每月29元包185G流量+100分钟通话, 中国电信官方发货

数据库用ms自带的驱动就可以了，建好数据原，写好连接代码连接代码如下：<%@ page language="java" import="java.sql.*" contentType="text/html;charset=gb2312"%>
<%
java.sql.Connection Conn;
java.sql.Statement Stmt;
java.sql.ResultSet Rst;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Conn=DriverManager.getConnection("jdbc:odbc:数据原名称","用户名","密码");
Stmt=Conn.createStatement();
%>
JdbcBean.java:
package SerialNo;import java.sql.*;
import java.io.*;
import java.util.*;
import java.util.Date.*;/**
* <p>Title: Wap Bean </p>
* <p>Description: Wap Bean is a java bean for wap site comporment
*    Usage: first use <jsp:useBean id="beanID" class="wapbean.jdbcbean" scope="session" /> to create jdbcbean object.
*           Then use jdbcInitial(); to initial jdbc
*           After use, please call unloadJDBC to release jdbc bean
* </p>
* <p>Copyright: Copyright (c) 2002</p>
* <p>Company: ITSG - TSNC</p>
* @author unascribed: Picasso Wang
* @version 1.0
*/public class JdbcBean {
public Connection conn = null;
public Statement stmt = null;
public String szErrorMessage = ""; public JdbcBean() {}
// Initial JDBC driver and create statement inorder to connect mysql database
public boolean initialJDBC()
{

try
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://srdtw:1433","Wap2","Wap2");
stmt = conn.createStatement(); // Create Statement stmt
return true;
}catch(Exception fs) {
    return false;
}


  }

  // Unload JDBC driver and relase connection and statement
  public void unloadJDBC()
  {
    try
    {
      if (conn != null)
        conn.close();      if (stmt != null)
        stmt.close();
    }
    catch (Exception e)
    {
      // do nothing
    }
    conn = null;
    stmt = null;
  }}jsp文件：
<%@ page contentType="text/html; charset=GBK" %>
<%@ page import="java.sql.*" %>
<%@ page import="java.util.*" %>
<%@ page import="java.io.*" %>
<jsp:useBean id="jdbcBeanID" class="SerialNo.JdbcBean" scope="page" /><html>
<title>JDBC²éÑ¯²âÊÔ±íµ¥</title>
<body>
<%
String msgStr=null;
String nickName = (String)session.getAttribute("nickName");
String pwd = (String)request.getParameter("pwd");

if (nickName=="" || nickName==null) nickName= request.getParameter("nickName");

if (nickName=="" || nickName==null) msgStr=null;
else
{
if (pwd=="" || pwd==null) msgStr="Password is empty";
else
{
if (jdbcBeanID.initialJDBC())
{
String sql = "Select * from UserTable where NickName = '" + nickName + "'";
ResultSet rs = jdbcBeanID.stmt.executeQuery(sql);
while (rs.next())
{
if (rs.getString("Password")==pwd) msgStr="true:"+rs.getInt("ID");
else msgStr="Password is wrong";
}
rs.close();
jdbcBeanID.unloadJDBC();
}//end if (jdbcBeanID.initialJDBC())

else msgStr="Connection Error";

}

}

if (msgStr.substring(0,5).equals("true"))
{
//ÕýÈ·£¬¿ÉÒÔµÇÂ½
session.setAttribute("nickName",nickName);
session.setAttribute("userID",msgStr.substring(6));

}
else if (msgStr!=null && msgStr!="")
{
out.println(msgStr);
%>
<form method="POST" action="login.jsp">
  <p>姓名<input type="text" name="nickName" size="13"></p>
  <p>密码<input type="text" name="pwd" size="13"></p>
  <p>    <input type="submit" value="提交" name="B1"> <input type="reset" value="重设" name="B2"></p>
</form>
<%
}
%>
</body>
</html>
另外我得odbc数据源找不到了，在控制面板下－》管理工具内，我得是空的，别人的都有。奇怪！
你的管理工具里是空的？什么都没有还是没有数据源 (ODBC) ？
是什么都没有！！！！
唉！
不过我已经更新了win2000,现在什么都有了！