jdbcutils工具

转载自博客园点击打开链接

package jdbctest;


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


public class JdbcUtils {
private static Properties props=null;
static {
//给propes进行初始化，即加载properties文件到props对象中去
try {
InputStream in=JdbcUtils.class.getClassLoader().getResourceAsStream("properties.properties");
props=new Properties();
props.load(in);
}catch(IOException e) {
throw new RuntimeException(e);
}
//加载驱动类
try {
Class.forName(props.getProperty("driverClassName"));
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public static Connection getConncetion() throws SQLException
{
return DriverManager.getConnection(props.getProperty("url"), props.getProperty("username"),props.getProperty("password"));
}
public static com.mysql.jdbc.Connection getConnection() {
// TODO Auto-generated method stub
return null;
}
}