swing 与sql-server数据库交互完整实例

1 建立数据库，建表。

   数据库：text表：fruit

2写db连接类

 

  public class DBConMgr {
 
 //private  String driverName="oracle.jdbc.driver.OracleDriver";    
 private  String driverName="com.microsoft.sqlserver.jdbc.SQLServerDriver";     
 private  String userName="sa";                     
 private  String userPwd="sa123456";                       
                                                          
    private  String url="jdbc:sqlserver://localhost:1433; DatabaseName=text";  
    public  Connection conn=null;                                
    public Statement sm=null;                                     
    public PreparedStatement psm=null;
 
    public void ConnectDB(){
      try {
       Class.forName(driverName).newInstance();
          conn=DriverManager.getConnection(url,userName,userPwd); 
          sm=conn.createStatement();
         
          System.out.println("success");
         } catch(Exception e) {
       e.printStackTrace();  
       System.out.println("连接错误");
      }
    }

   
    public void CloseDB(){
     try {
   if (sm != null) {
    sm.close();
   }
   if(psm!=null)
   {
    psm.close();
   }
   conn.close();
  } catch (SQLException SqlE) {
   SqlE.printStackTrace();
    System.out.println("-关闭错误");
  }
   
   }

3 画界面

 我用的是myeclipse-swingfrom

 

 

4切换界面到Source

 添加鼠标动作：

//确定，插入数据库

private void jButton1MouseClicked(java.awt.event.MouseEvent evt) {
  // TODO add your handling code here:

  String Name1 = new String(jTextField1.getText());
  String Level1 = new String(jTextField2.getText());
  DBConMgr db_conn = new DBConMgr();
  db_conn.ConnectDB();
  Connection conn = db_conn.conn;
  //Statement stat = db_conn.sm;
  //PreparedStatement psm =db_conn.psm;

  //  PreparedStatement psm =db_conn.psm;

  try {
   String sql = "insert into fruit(name,level) values(?,?)";
   PreparedStatement psm = conn.prepareStatement(sql);
   psm.setString(1, Name1);
   psm.setString(2, Level1);
   psm.executeUpdate();

   JOptionPane.showMessageDialog(null, "数据已成功插入！");//弹出对话框
} catch (Exception ee) {
   System.out.print("exception");
   ee.printStackTrace();
  }
 }
//取消，清空

private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {
  // TODO add your handling code here:
  jTextField1.setText("      ");
  jTextField2.setText("      ");
 }

运行：

 

 

 

数据库：