/**
已安装了microsoft 驱动程序
jdk1.4; win2000 server; MS sql2000;
*/
import java.sql.*;
class sql
{
public static void main(String[] agrs)
{
Connection cn=null;
Statement stmt=null;
String sql=null;
try
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
}
catch(ClassNotFoundException ex)
{
System.out.println("Not find the Driver!");
}
try
{
String urls="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=webroot";//webroot 库名.TALBE 是表名;
String user="sa";
String password="password";
cn= DriverManager.getConnection(urls,user,password);
//stmt=cn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
stmt=cn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
sql="select top 10 * from TABLE1";
ResultSet rs= stmt.executeQuery(sql);
while(rs.next())
{
System.out.println(rs.getString(2)+" "+rs.getString(3));
}
rs.first();
System.out.print(rs.getRow()+" ");
System.out.println(rs.getString(2)+" 1 "+rs.getString(3));
rs.last();
System.out.print(rs.getRow()+" ");
System.out.println(rs.getString(2)+" 2 "+rs.getString(3));
rs.previous();
System.out.print(rs.getRow()+" ");
System.out.println(rs.getString(2)+" 3 "+rs.getString(3));
rs.next();
System.out.print(rs.getRow()+" ");
System.out.println(rs.getString(2)+" 4 "+rs.getString(3));
rs.absolute(2);
System.out.print(rs.getRow()+" ");
System.out.println(rs.getString(2)+" 5 "+rs.getString(3));
/*
rs.afterLast();
System.out.print(rs.getRow()+" ");
System.out.println(rs.getString(2)+" "+rs.getString(3));
System.out.print(rs.isAfterLast());
rs.beforeFirst();
System.out.print(rs.getRow()+" ");
System.out.println(rs.getString(2)+" "+rs.getString(3));
*/
String sql1="update TABLE1 set 题目=? where id=? ";
PreparedStatement stmt1 = cn.prepareStatement(sql1);
String stat = new String("盛夏话足部保健");
String stat1 = UnicodeToGB(stat);//解决中文问题
stmt1.setString(1,stat1);
stmt1.setInt(2,3423);
stmt1.executeUpdate();
cn.commit();
//System.out.println(stat1);
//System.exit(0);
//cn.setAutoCommit(false);
stmt.addBatch("update TABLE1 set 题目='盛夏话足部保健1' where id='3407'");
stmt.addBatch("update TABLE1 set 题目='夏季预防中暑膳食1' where id='3408'");
stmt.addBatch("INSERT INTO TABLE1 VALUES('11','12','13','','')");
stmt.addBatch("INSERT INTO TABLE1 VALUES('12','12','13','','')");
stmt.addBatch("INSERT INTO TABLE1 VALUES('13','12','13','','')");
stmt.addBatch("INSERT INTO TABLE1 VALUES('14','12','13','','')");
stmt.addBatch("INSERT INTO TABLE1 VALUES('15','12','13','','')");
stmt.addBatch("INSERT INTO TABLE1 VALUES('16','12','13','','')");
stmt.addBatch("INSERT INTO TABLE1 VALUES('17','12','13','','')");
stmt.addBatch("INSERT INTO TABLE1 VALUES('18','12','13','','')");
int [] updateCounts=stmt.executeBatch();
cn.commit();
stmt.close();
cn.close();
}
catch(SQLException e)
{
System.out.println("The SQLException error!");
}
}
/*
*/
public static String UnicodeToGB(String strIn){
byte[] b;
String strOut = null;
if(strIn == null || (strIn.trim()).equals(""))
return strIn;
try{
b = strIn.getBytes("GBK");
strOut = new String(b,"ISO8859_1");
}
catch(Exception e){
System.out.println("unicodeToGB exception : " + e.getMessage() + "\n");
}
return strOut;
}
/*
*/
}