数据库桥连实例代码

来源：互联网发布：电影韩国鬼魅知乎编辑：程序博客网时间：2024/06/05 03:51

Connection con = null;
Statement stmt = null;
int row = 0;
//获取GUI信息
String stuID = stuIDTextField.getText();
String stuName = stuNameTextField.getText();
String stuDepart = (String) departComboBox.getSelectedItem();
String stuClass = (String) classComboBox.getSelectedItem();
//检测
if (stuID.equals("") || stuName.equals("")) {
    JOptionPane.showMessageDialog(this, "请填写完整");
        return;
} else {
   try {
      //注册桥接驱动
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
      //建立与数据源的连接
      con = DriverManager.getConnection("jdbc:odbc:studentodbc", "sa", "sql2008");
      //创建执行语句,拼接字符串
       String insertsql = "insert studentinfo values('" + stuID + "','" + stuName + "','" + stuDepart + "','" + stuClass + "')";
            System.out.println(insertsql);

stmt = con.createStatement();
            //发送sql语句
            row = stmt.executeUpdate(insertsql);
            if (row != 0) {
                JOptionPane.showMessageDialog(this, "添加成功");
                stuIDTextField.setText("");
                stuNameTextField.setText("");
            } else {
                JOptionPane.showMessageDialog(this, "添加失败");
            }
        } catch (Exception ex) {
            ex.printStackTrace();
        } finally {
            try {
                con.close();//关闭连接

            } catch (Exception ex) {
                ex.printStackTrace();
            }
        }
    }注意：驱动的加载和数据库的操作