//将下面的两个方法放到程序里面调用就可以了
public class ConnectMysql {
static String driver;
static String url;
static String user;
static String pass;
public void getParam(String param) throws Exception{
Properties prop = new Properties();
prop.load(new FileReader(param));
driver = prop.getProperty("driver");
url = prop.getProperty("url");
user = prop.getProperty("user");
pass = prop.getProperty("pass");
}
public void createTable(String sql){
CachedRowSet cachedRs = null;
try{
Class.forName(driver);
}
catch(ClassNotFoundException cn){
cn.printStackTrace();
}
try(
Connection conn = DriverManager.getConnection(url,user,pass);
PreparedStatement pstmt = conn.prepareStatement(sql);
ResultSet rs = pstmt.executeQuery())
{
//这里面就是各种语句了哈
//如果不需要rs的,那么就去掉上面的ResultSet语句,添加pstmt.execute()
}
catch(SQLException sl){
sl.printStackTrace();
}
finally{}
}