首先,你先下载一个jtds的包(jtds.jar)连接sqlserver数据库的!
然后配置好,运行下面的程序就ok了
我认为它比jdbc的连接更稳定,效率更好! 推荐一下吧!
<%
try{
Class.forName("net.sourceforge.jtds.jdbc.Driver");
System.out.print("ddddd1");
Connection con = DriverManager.getConnection("jdbc:jtds:sqlserver://127.0.0.1:1433/pubs","sa","sa");
System.out.print("ddddd2");
Statement stmt = con.createStatement(1005,1008);
String sql="select * from authors";
ResultSet rs = stmt.executeQuery(sql);
if(rs.next())
{
System.out.print("连接成功");
}
}catch(Exception ex){
ex.printStackTrace();}
%>