import java.sql.*;
public class ConnectionBean{
static Statement st;
public static Statement getStatement(int pa1,int pa2){
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orclsid","jike","jike");
st=con.createStatement(pa1,pa2);
System.out.println("jik");
}
catch(Exception ex){ex.printStackTrace();}
return st;
}
public static void main(String args[])
{
try{
int i=0;
Statement ste=ConnectionBean.getStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from ok";
ResultSet rs=ste.executeQuery(sql);
if(rs!=null)
{
while(rs.next()){
System.out.println(rs.getString("name")+" "+rs.getString("date"));
//ConnectionBean.getStatement(1,2);
System.out.println("好啊");
i++;
System.out.println(i);
}
}
}catch(Exception e)
{
e.printStackTrace();
}
System.out.println("safdsdfsd");
}
}
sqlserver的連接與此類(lèi)同
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
con=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;databasename=stu","sa", "sa");
聯(lián)系客服