dbcon.java~17~

来自「jtable 数据库的一个小例子」· JAVA~17~ 代码 · 共 57 行

package jtabletest;

import java.sql.*;

public class DBCON {
    private static Connection con;
    Statement sta = null;
    ResultSet rs = null;
    private final String DRIVER = "sun.jdbc.odbc.JdbcOdbcDriver";
    private final String URL = "jdbc:odbc:test";

    public DBCON() {
    }

    /*
     连接驱动
     创建连接
     */
    public void Connect() {
        try {
            Class.forName(DRIVER);
        } catch (ClassNotFoundException ex) {
            System.out.println(ex);
        }
        if (con == null) {
            try {
                con = DriverManager.getConnection(URL);
                sta = con.createStatement();
            } catch (SQLException ex) {
                System.out.println("连接数据库错误" + ex.getMessage());
            }
        }
    }

    /*
     插入信息
     */
    PreparedStatement ps;
    public void insert(String name, int age, String address) {
        try {
            ps = con.prepareStatement("Insert into Student values(?,?,?)");
            ps.setString(1, name);
            ps.setInt(2, age);
            ps.setString(3, address);
            ps.executeUpdate();
        } catch (SQLException ex) {
            System.out.println("输入信息发生异常:" + ex.getMessage());
        }
    }
    
    /*
     查询数据
     */
    public void search(){
        ps = con.prepareStatement("select * from Student");
    }
}