展开全部
我帮你改32313133353236313431303231363533e78988e69d8331333335306264了下,数据库我也稍微改了一下,你参考一下吧。。。
我新建了一个teacher数据库,新建表:create table peo(Name char(255),Job char(255),Jbie char(255),msDate char(255),Ward char(255));
Java代码:import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
public class Jdbc2 {
public static void main(String[] args) {
// DataCenter dc= new DataCenter();
String dbUrl = "jdbc:mysql://127.0.0.1:3306/teacher";
String user = "root";
String password = "password";
try {
// Load the driver (registers itself)
Class.forName("com.mysql.jdbc.Driver");
}catch(Exception e){
System.out.println("数据库驱动加载失败");
}
try{
Connection c = DriverManager.getConnection(dbUrl, user, password);
Statement s = c.createStatement();
boolean r;
r = s.execute("insert into peo(Name,Job,Jbie,msDate,Ward) values ('11','助教','2','23','329')");//插入时需要用.execute();
ResultSet rs=s.executeQuery("select * from peo");//对比一下
s.close(); // Also closes ResultSet
} catch (Exception e) {
e.printStackTrace();
System.out.println("数据库连接失败");
}
}
} // /:~