lijun175165
发贴: 1
积分: 0
|
于 2006-11-10 11:01
我已经在netBeans中加入驱动(只限于从IDE连接数据库):运行环境—〉数据库—〉驱动程序—〉添加sqlserver jdbc驱动,测试连接成功! 但在JSP项目中,我在调试时发现在Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");或Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance;时出错,已改为SQL Sever 身份验证。请大家多多指教!!! 连接数据库的类如下: package myBeanPackage;
/** * * @author HUA1 */ import java.io.*; import java.sql.*; import java.util.*;
public class myBean {
private Connection connection = null; //定义与数据库进行连接的Connection对象 private Statement statement = null; //定义查询数据库的Statement对象 private ResultSet rs = null; //定义数据库查询的结果集
public myBean() { }
public ResultSet getTableData(String tableName) //根据用户指定的表名取出表中数据并返回 { try { Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs"; //指定数据源名 String user = "sa"; String pwd =""; connection = DriverManager.getConnection(url,user,pwd); //与数据源建立连接 String sql = "select * from " + tableName; //创建取出用户指定表中所有数据的SQL语句 Statement statement = connection.createStatement(); //创建Statement接口实例 ResultSet rs = statement.executeQuery(sql); //将数据存入结果集中 return rs; } catch(SQLException ex){ //捕捉异常 System.out.println("\nERROR:----- SQLException -----\n"); while (ex != null) { System.out.println("Message: " + ex.getMessage()); System.out.println("SQLState: " + ex.getSQLState()); System.out.println("ErrorCode: " + ex.getErrorCode()); ex = ex.getNextException(); } } catch(Exception ex ) { ex.printStackTrace(); } return null; } }
调用的Bean如下: <%@page contentType="text/html;chareset=GBK" %> <%@page pageEncoding="UTF-8"%>
<jsp:useBean id='myBean' scope='page' class='myBeanPackage.myBean' type="myBeanPackage.myBean" /> <html> <body> <% out.print("Connect Database!"); //dbbean myBean = new dbbean(); java.sql.ResultSet rs = myBean.getTableData("table1"); rs.next(); out.println(rs.getString(1)); %> </body> </html>
|