Java 使用execute方法执行Sql语句。
mysql.ini是一个配置文件。配置内容可以看上一篇。
class ExecuteSql {
private String driver;
private String url;
private String user;
private String pass;
Connection conn;
Statement stmt;
ResultSet rs;
public void initParam(String paramFile) throws Exception {
Properties props = new Properties();
props.load(new FileInputStream(paramFile));
driver = props.getProperty("driver");
url = props.getProperty("url");
user = props.getProperty("user");
pass = props.getProperty("pass");
}
public void executeSql(String sql) throws Exception{
try {
Class.forName(driver);
conn = DriverManager.getConnection(url,user,pass);
stmt = conn.createStatement();
boolean hasResultSet = stmt.execute(sql);
if (hasResultSet) {
rs = stmt.getResultSet();
java.sql.ResultSetMetaData rsmd = rs.getMetaData();
int columnCount = rsmd.getColumnCount();
while (rs.next()) {
for (int i = 0; i < columnCount; i++) {
System.out.print(rs.getString(i+1) + "\t");
}
System.out.println();
}
}
else {
System.out.println("改SQL语句影响的记录有" + stmt.getUpdateCount() + "条");
}
}
finally
{
if (rs != null) {
rs.close();
}
if (stmt != null) {
stmt.close();
}
if (conn != null) {
conn.close();
}
}
}
/**
* @param args
* @throws Exception
*/
public static void main(String[] args) throws Exception {
// TODO Auto-generated method stub
ExecuteDDL ed = new ExecuteDDL();
ed.initParam("src/mysql.ini");
ed.executeSql("drop table if exists school"); //(insertSql);
ed.executeSql("create table school(id int, name varchar(50), addr varchar(50))");
ed.executeSql("insert into school values(1, 'No1', 'BeiJing')");
ed.executeSql("select * from school");
}
}
执行结果为：
