输入表名称
生成增删改查的sql语句,适用于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 {
//关闭连接
}
}