求JAVA代码……增删改查SQL2000数据库！

[czs479]

给个范例就行 ，做个简单的教育经历管理系统，就几张表

要简单的！越简单越好
尤其修改和删除！

[GkfSyser]

public class UserSystem {
 public static void main(String args[]){
  UserSystemDAO UserSystemDAO=new UserSystemDAO();
 }
}
 
 
 
import java.sql.*;
public class UserSystemDAO {
 
 String insertSql="insert into table_usersystem_dictionary values(?,?,?,?)";
 
 UserSystemDAO(){
  executeSQL();
 }
 private void executeSQL(){
  UserSystemDB userSystemDB=new UserSystemDB();
  
  PreparedStatement preparedStatement=null;
  
  Connection connection=userSystemDB.createConnection();
  
  try{
   preparedStatement=connection.prepareStatement(insertSql);
   preparedStatement.setString(1, "95002");
   preparedStatement.setString(2,"user");
   preparedStatement.setString(3,"shl");
   preparedStatement.setString(4,"001");
   preparedStatement.addBatch();
   preparedStatement.executeBatch();
   preparedStatement.close();
   System.out.println("Insert success");
  }
  catch(Exception e){e.printStackTrace();}
  finally{
   try{
    connection.close();
   }
   catch(Exception e){e.printStackTrace();}
  }
 }
}
 
 
 
import java.sql.Connection;
import java.sql.DriverManager;
public class UserSystemDB {
  
 public Connection createConnection(){
  Connection connection=null;
  try{
  
   Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
   //String url="jdbc:odbc:argon";
   String url="jdbc:microsoft:sqlserver://Localhost:1433;DatabaseName=user";
   connection=DriverManager.getConnection(url,"sa","");
   System.out.println("JDBC-ODBC的驱动程序注册成功");
  
  }
  catch(Exception e){
   e.printStackTrace();
   System.out.println("找不到驱动程序");
  }
  return connection;
 }
}

[GkfSyser]

更新用preparedStatement.update 你看下java基础吧

[GkfSyser]

这种基础问题先百度下再问

[lihan6415151528]

路过，关注

[timbear]

一楼的代码够用了～～

[GkfSyser]

更新是这个preparedStatement.excuteupdate 2楼错了 不好意思