jdbc.java

这是java编写宠物医院项目

package jdbc;
import java.sql.*;
public class JDBC {
    private static Connection con=null;
    public JDBC() {
    }
    public static Connection getConnection(){
        if(con==null){
            try{
                Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            }catch(ClassNotFoundException ex){
                ex.printStackTrace();
            }
            try{
                con=DriverManager.getConnection("jdbc:odbc:sa;characterEncoding=utf-8","","");
            }catch(SQLException ex1){
                ex1.printStackTrace();
            }
        }//缁撴潫 if
        return con;
    }
    public static void CloseConnection(){
        if(con!=null){
            try{
                con.close();
            }catch(SQLException ex){
            }
            con=null;
        }
    }
    public static void main (String[] args){
        Connection con=JDBC.getConnection();
        if(con!=null){
            System.out.println("ok......");
            JDBC.CloseConnection();
        }else
            System.out.println("no......");
    }
}