try
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
}
catch(java.lang.ClassNotFoundException e)
{
System.out.println("ClassNotFoundException:");
System.out.println(e);
}
catch (InstantiationException e)
{
// TODO Auto-generated catch block
e.printStackTrace();
}
catch (IllegalAccessException e)
{
// TODO Auto-generated catch block
e.printStackTrace();
}
try
{
String url="jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=pubs";
Connection con=DriverManager.getConnection(url,"sa","sql");
Statement stmt=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
ResultSet rs=stmt.executeQuery("select * from authors");//(2)发送SQL语句到数据库中
while(rs.next())
{
String au_fname=rs.getString("au_fname") ; //(3)处理数据并查询结果。
int contract=rs.getInt("contract");
float zip=rs.getFloat("zip");
out.println("au_fname:"+au_fname+",contract"+contract+",zip:"+zip+"<br/>");
}
rs.close(); //(4)关闭
stmt.close();
con.close();
}
catch(SQLException ex)
{
out.println("SQLException: " + ex.getMessage());
}