生成代码工具（复习下jdbc）

输入表名称
生成增删改查的sql语句，适用于jdbc项目

public static void printSqlByTableName(String tableName) throws SQLException {
		if (tableName == null || tableName.trim().equals(""))
			return;
		String sql = "select * from " + tableName + " where 1=2";
				Connection con = null;
		try {
						con = null;//获得连接
			PreparedStatement pstmt = con.prepareStatement(sql);
			ResultSet resultSet = pstmt.executeQuery();
			if (resultSet != null) {
				ResultSetMetaData metaData=resultSet.getMetaData();
				int columncount = metaData.getColumnCount();
				StringBuffer insertSql = new StringBuffer("insert into " + tableName + "(");
				StringBuffer updateSql=new StringBuffer("update "+tableName+" set");
				StringBuffer selectSql=new StringBuffer("select * from "+tableName +" t where 1=1 \r\n");
				StringBuffer deletSql=new StringBuffer("delete "+tableName+" where Id=?");
				for (int i = 1; i <= columncount; i++) {
					if (i != 1) {
						insertSql.append(",");
						updateSql.append(",");
					}
					insertSql.append(metaData.getColumnName(i));
					updateSql.append(" "+metaData.getColumnName(i)+"=?");
					selectSql.append(" and t."+metaData.getColumnName(i)+"=?\r\n");
				}
				insertSql.append(")values(");
				updateSql.append(" where ID=?");
				for (int i = 1; i <= columncount; i++) {
					if (i != 1) {
						insertSql.append(",");
					}
					insertSql.append("?");
				}
				insertSql.append(")");
				System.out.println(insertSql);
				System.out.println(updateSql);
				System.out.println(deletSql);
				System.out.println(selectSql);
			}
			if (null != resultSet)
				resultSet.close();
			if (null != pstmt)
				pstmt.close();
		} finally {
			//关闭连接
		}
	}