String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=数据库名";
String user ="sa";//这里替换成你自已的数据库用户名
String password = "sa";//这里替换成你自已的数据库用户密码
try{ //这里的异常处理语句是必需的.否则不能通过编译!
Driver driver = (Driver)Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
DriverManager.registerDriver(driver);
System.out.println( "类实例化成功!" );
con = DriverManager.getConnection( url, user, password );
System.out.println( "创建连接对像成功!" );
st = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
System.out.println( "创建Statement成功!" );
}
catch(Exception err){
err.printStackTrace(System.out);
}
String user ="sa";//这里替换成你自已的数据库用户名
String password = "sa";//这里替换成你自已的数据库用户密码
try{ //这里的异常处理语句是必需的.否则不能通过编译!
Driver driver = (Driver)Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
DriverManager.registerDriver(driver);
System.out.println( "类实例化成功!" );
con = DriverManager.getConnection( url, user, password );
System.out.println( "创建连接对像成功!" );
st = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
System.out.println( "创建Statement成功!" );
}
catch(Exception err){
err.printStackTrace(System.out);
}
{
public static void main (String[] args)
{
try
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver" );
Connection connection = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;databasename=WEB;SelectMethod=direct", "sa","sa");
Statement stmt = connection.createStatement();
String s = "SELECT aaa, bbb FROM AAA";
ResultSet rs = null;
rs = stmt.executeQuery(s);
System.out.println("Success! The following are the rows in this query:");
String aaa;
String bbb;
while (rs.next())
{
aaa = rs.getString("aaa"); //fails if in this order
bbb = rs.getString("bbb");
//password = rs.getString("password");
//re = rs.getString("re"); //works fine if in this order
System.out.println(aaa + ", " + bbb);
}
rs.close();
stmt.close();
connection.close();
} catch(Exception e)
{
System.out.println(" Exception = " + e );
}
try
{
System.out.println("Press any key to quit...");
System.in.read();
}
catch (Exception e)
{ }
}
}
我是想怎么写一个连接池bean来连接数据库,这样效率也比较高,而且移植性比较强,
以上的方法我都实现了,jdbc还是有点慢不过还是一要谢谢两位大虾的参与了!!!
写一个servlet,把初始化参数写到web.xml文件,
给这个servlet一个mapping,假设为/dbinit
把数据库连接池的生成,初始化等等放在servlet的service()方法中,并且把连接池对象放入ServletContext中,假设名字叫做pool.
在jsp中使用bean
<jsp:useBean class="packagexx.DbPool" id="pool" scope="application"/>
这样就可以了.
重启server后,首先访问/dbinit,完成连接池的初始化.
后面就可以用了.