MySQL模板

//将下面的两个方法放到程序里面调用就可以了
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{}
        }