package opendb;
import java.sql.*;
public class Opendb {
String sDBDriver="com.microsoft.jdbc.sqlserver.SQLServerDriver";
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=rshos";
String user="sa";
String password="";
Connection conn=null;
ResultSet rs=null; public Opendb(){
try{
Class.forName(sDBDriver);
}
catch(java.lang.ClassNotFoundException e){
System.err.println("Opendb():"+e.getMessage());
}
//String strsql="select * from user1";
//System.out.println(rs);
} public ResultSet executeQuery(String sql){
rs=null;
try{
conn= DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
rs=stmt.executeQuery(sql);
}
catch(SQLException ex)
{
System.err.println("aq.executeQuery:"+ex.getMessage());
}
return rs;
}
public static void main(String[] args)
{
Opendb db=new Opendb();
try{
ResultSet rs=db.executeQuery("select P_id from P_base");
while(rs.next())
{
System.out.println(rs.getString("P_id"));
}
}
catch(Exception e){System.out.println("000");};
}
}按理说,应该自动生成opendb文件夹才对啊,可是不能生成.
不知道为什么啊
import java.sql.*;
public class Opendb {
String sDBDriver="com.microsoft.jdbc.sqlserver.SQLServerDriver";
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=rshos";
String user="sa";
String password="";
Connection conn=null;
ResultSet rs=null; public Opendb(){
try{
Class.forName(sDBDriver);
}
catch(java.lang.ClassNotFoundException e){
System.err.println("Opendb():"+e.getMessage());
}
//String strsql="select * from user1";
//System.out.println(rs);
} public ResultSet executeQuery(String sql){
rs=null;
try{
conn= DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
rs=stmt.executeQuery(sql);
}
catch(SQLException ex)
{
System.err.println("aq.executeQuery:"+ex.getMessage());
}
return rs;
}
public static void main(String[] args)
{
Opendb db=new Opendb();
try{
ResultSet rs=db.executeQuery("select P_id from P_base");
while(rs.next())
{
System.out.println(rs.getString("P_id"));
}
}
catch(Exception e){System.out.println("000");};
}
}按理说,应该自动生成opendb文件夹才对啊,可是不能生成.
不知道为什么啊
就可以了