Java连接SQL Server数据库实现数据操作

package pag;
import java.sql.*;
public class zuoye{

/**
 * @param args
 */
public static void main(String[] args) {
// TODO Auto-generated method stub
try{
String driverName = "net.sourceforge.jtds.jdbc.Driver";
        String dbURL="jdbc:jtds:sqlserver://localhost:1433;DatabaseName=zyxt";
        Driver driver = (Driver) Class.forName(driverName).newInstance();
        DriverManager.registerDriver(driver);            
        Connection conn =DriverManager.getConnection(dbURL,"sa","sa");
        Statement stmt=conn.createStatement();
        //下面访问数据库的代码
     //  ResultSet rs=stmt.executeQuery("SELECT * FROM Datacode");
 // ResultSet rs=stmt.executeQuery("insert into Datacode values('112202003','采油二矿三队')");
    //  ResultSet rs=stmt.executeQuery("delete from Datacode where Dno='112202'");
        ResultSet rs=stmt.executeQuery("update Datacode set Dno='112204' where Dno='112202001' ");
     while(rs.next()){
         System.out.println("单位名称="+rs.getString("Dno"));
         System.out.println("单位名称="+rs.getString("Dname"));
        
        }
}catch(Exception e){
System.out.println(e);
}