只是很基本的代码,没什么特别的东西,自己给自己做一下备份而已。
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;
public class JDBCDemo {
public static void main(String[] args) {
String user = "root";
String password = "123456";
String url = "jdbc:mysql://localhost:3306/mydb";
String driver = "com.mysql.jdbc.Driver";
String tableName = "studinfo";
String sqlstr;
Connection con = null;
Statement stmt = null;
ResultSet rs = null;
try {
Class.forName(driver);
con = DriverManager.getConnection(url, user, password);
stmt = con.createStatement();
sqlstr = "insert into " + tableName
+ " values ('001','test',100)";
stmt.executeUpdate(sqlstr);
sqlstr = "select * from " + tableName;
rs = stmt.executeQuery(sqlstr);
ResultSetMetaData rsmd = rs.getMetaData();
int j = 0;
j = rsmd.getColumnCount();
for (int k = 0; k < j; k++) {
System.out.print(rsmd.getCatalogName(k + 1));
System.out.print("\t");
}
System.out.println();
while (rs.next()) {
for (int i = 0; i < j; i++) {
System.out.print(rs.getString(i + 1));
System.out.print("\t");
}
System.out.println();
}
} catch (ClassNotFoundException e1) {
System.out.println("database error!");
System.out.println(e1.toString());
} catch (SQLException e2) {
System.out.println("database error!");
System.out.println(e2.toString());
} finally {
try {
if (rs != null)
rs.close();
if (stmt != null)
stmt.close();
if (con != null)
con.close();
} catch (SQLException e) {
System.out.println(e.toString());
}
}
}
}