jdbc 连接数据库

java jdbc 连接数据库

package com.tjetc.dbutil;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class DBConn {
	//三属性
	private Connection conn;  //连接
	private Statement stmt;	  //执行对象，用于执行sql语句
	private ResultSet rs;	  //结果集，用于保存查询的结果	
	//构造方法
	public DBConn(){
		try {
			Class.forName("com.mysql.jdbc.Driver");
			String url="jdbc:mysql://localhost:3306/project";
			this.conn=DriverManager.getConnection(url,"root","1");
			stmt=conn.createStatement();
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}	
	//查询的方法
	public ResultSet execQuery(String strSql){
		try {
			rs=stmt.executeQuery(strSql);
			return rs;
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			return null;
		}
	}	
	//执行增删改的方法
	public int execOther(String strSql){
		try {
			int flag=stmt.executeUpdate(strSql);
			return flag;
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			return -1;
		}
	}	
	//关闭
	public void closeAll(){
		try {
			if(!rs.isClosed()){
				rs.close();
			}
			if(!stmt.isClosed()){
				stmt.close();
			}
			if(!conn.isClosed()){
				conn.close();
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

}

直接调用该类 连接数据库