dbcon.java~20~

jtable 数据库的一个小例子

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) {
        this.connect();
        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(){
//        try {
//            ps = con.prepareStatement("select * from Student");
//            rs = ps.executeQuery();
//            while(rs.next()){
//
//            }
//        } catch (SQLException ex) {
//        }
//    }
    public void closeDB() {
        try {
            con.close();
            sta.close();
            rs.close();
            ps.close();
        } catch (SQLException ex) {
            System.out.println("关闭连接发生异常:" + ex.getMessage());
        }

    }
}