package sqltest;import java.sql.*;
import java.util.*;
public class SqlTest
{
Connection conn;
Statement stat;
String user = "sa";
String password = "";
String driver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
//String driver = "sun.jdbc.odbc.JdbcOdbcDriver";
String url="jdbc:microsoft:sqlserver://localhost:1433;DataBaseName=test";
//String url="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=db1.mdb";
public SqlTest(){
try{
Class.forName(driver);
conn = DriverManager.getConnection(url,user,password);
//stat = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
stat=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE); //stat = conn.createStatement();
}
catch(ClassNotFoundException e){
System.out.println("驱动加载错误");
e.printStackTrace();
}
catch(SQLException e){
e.printStackTrace();
}
}
public ResultSet getRs(String sql){
ResultSet res = null;
try{
res = stat.executeQuery(sql);
}
catch(SQLException e)
{
e.printStackTrace();
}
return res;
}
public boolean execute(String sql){
boolean bool = false;
try{
bool = stat.execute(sql);
}
catch(Exception e){
e.printStackTrace();
}
return bool;
}
public static void main(String []args)
{
try{
SqlTest sqltest = new SqlTest();
ResultSet rs = sqltest.getRs("select * from na") ;
while(rs.next()){
System.out.println(rs.getLong(5));
System.out.println("123");
}
//sqltest.execute("insert into stu values('1','false')"); }
catch(Exception e)
{
e.printStackTrace();
}
}
}
import java.util.*;
public class SqlTest
{
Connection conn;
Statement stat;
String user = "sa";
String password = "";
String driver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
//String driver = "sun.jdbc.odbc.JdbcOdbcDriver";
String url="jdbc:microsoft:sqlserver://localhost:1433;DataBaseName=test";
//String url="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=db1.mdb";
public SqlTest(){
try{
Class.forName(driver);
conn = DriverManager.getConnection(url,user,password);
//stat = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
stat=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE); //stat = conn.createStatement();
}
catch(ClassNotFoundException e){
System.out.println("驱动加载错误");
e.printStackTrace();
}
catch(SQLException e){
e.printStackTrace();
}
}
public ResultSet getRs(String sql){
ResultSet res = null;
try{
res = stat.executeQuery(sql);
}
catch(SQLException e)
{
e.printStackTrace();
}
return res;
}
public boolean execute(String sql){
boolean bool = false;
try{
bool = stat.execute(sql);
}
catch(Exception e){
e.printStackTrace();
}
return bool;
}
public static void main(String []args)
{
try{
SqlTest sqltest = new SqlTest();
ResultSet rs = sqltest.getRs("select * from na") ;
while(rs.next()){
System.out.println(rs.getLong(5));
System.out.println("123");
}
//sqltest.execute("insert into stu values('1','false')"); }
catch(Exception e)
{
e.printStackTrace();
}
}
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货