将JDBC写成一个静态类

package jdbc.util;

import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;

public class JDBC {
	static String  driverClass=null;
	static String name=null;
	static String password=null;
	static String url=null;
static{
	try {
		Properties properties=new Properties();
		InputStream is=JDBC.class.getClassLoader().getResourceAsStream("jdbc.properties");
		properties.load(is);
		//读取属性
		driverClass = properties.getProperty("driverClass");
		url = properties.getProperty("url");
		name = properties.getProperty("name");
		password = properties.getProperty("password");
	} catch (IOException e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	}
}
public static Connection setConnetcion() {
	Connection conn=null;
	try {
		Class.forName(driverClass);
		conn=DriverManager.getConnection(url, name, password);
		
	} catch (Exception  e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	} 
	return conn;
	
}
public static void closejdbc(ResultSet re,Statement statement,Connection con) {
	closeRe(re);
	closeStatment(statement);
	closeCon(con);
}
private static void closeRe(ResultSet re) {
	try {
		if(re!=null)
		{
			re.close();
			
		}
	} catch (Exception e) {
		// TODO: handle exception
	}
}
private static void closeStatment(Statement statment) {
	try {
		if(statment!=null)
		{
			statment.close();
		}
	} catch (Exception e) {
		// TODO: handle exception
	}
}
private static void closeCon(Connection con) {
	try {
		if(con!=null)
		{
			con.close();
		}
	} catch (Exception e) {
		// TODO: handle exception
	}
}
}

jdbc.properties

driverClass=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost/store
name=root
password=sasa

Main.class

package jdbc.first;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import com.mysql.jdbc.Driver;

import jdbc.util.JDBC;

public class main {

	public static void main(String[] args) {
		
		try {
			Connection con=JDBC.setConnetcion();
			String sql="SELECT * FROM product WHERE cno=(SELECT cid FROM category WHERE cname="手机数码")";
			Statement state=con.createStatement();
			ResultSet res=state.executeQuery(sql);
			while(res.next())
			{
				System.out.println(res.getString("pname"));
			}
			JDBC.closejdbc(res, state, con);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
		
		// TODO Auto-generated method stub
		
	}

}