dbconnection.java

来自「一个简单的Java数据库连接 这个是一个关于MySQL的数据库连接」· Java 代码 · 共 33 行

import java.sql.*;
import java.lang.*;

public class DBConnection {
	Connection conn = null;
	//Statement stmt=null;
	//ResultSet rs= null;
	DBConnection(){
		try{
			Class.forName("com.mysql.jdbc.Driver");
		    conn = DriverManager.getConnection("jdbc:mysql://localhost/mydata?"+
			    	                    "user=root&password=123");
		    //stmt=conn.createStatement();
	        }catch (SQLException ex){
	        	System.out.println("SQLException: " + ex.getMessage());
                System.out.println("SQLState: " + ex.getSQLState());
                System.out.println("VendorError: " + ex.getErrorCode());
            }catch (Exception ex) {
                ex.printStackTrace();
            }finally{
                try{
        	        if(conn!=null){conn.close();conn=null;}
        	//if(stmt!=null){stmt.close();stmt=null;}
        	//if(rs!=null){rs.close();rs=null;}
        	       }catch(SQLException ex){
        		     ex.printStackTrace();
        	       }    	
        }
    }
    
    
}