再贴一帖:告诉我这程序为什么不能检索数据库!
import java.io.*;
import java.sql.*;
public class sqlBean{
public sqlBean(){
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
}
catch(java.lang.ClassNotFoundException e){}
catch(Exception e){
e.toString();
}
}
public String Query(String sql){
String pd="";
try{
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=test";
String user="sa";
String password="pzw6436008";
Connection conn=DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
ResultSet rs=stmt.executeQuery(sql);
if(rs.next()){
pd=rs.getString("password");
}
}
catch(SQLException e)
{
e.toString();}
return pd;
}
public static void main(String args[]){
sqlBean db=new sqlBean();
String pd=db.Query("select * from login");
System.out.println("the password is"+pd);
}
}
我已经装过JDBC驱动!