MySQL数据库job怎么写_下面是通过JDBC访问MySQL数据库pubs中的表jobs的一段代码，表jobs的字段及类型为：job_id int, job_desc v...

最好有详解/加载MysqlDriver类Class.forName("");System.out.println("加载Driver类成功");//建立数据库连接Connectionconn=DriverManager.("jdbc:mysql://localhost:3306/","pubs","...

最好有详解

/加载Mysql Driver类

Class.forName(" ");

System.out.println("加载Driver类成功");

//建立数据库连接

Connection conn = DriverManager. ("jdbc:mysql://localhost:3306/ ", "pubs","pubs");

System.out.println("建立连接成功");

stmt = conn.createStatement();

String sql = "select * from customers";

//执行SQL语句，返回结果集

rs = stmt. (sql);

System.out.println("SQL语句执行成功");

//遍历结果集内容

while (rs. ()) {

int job_id = rs.getInt(1);

String job_desc = rs. (2);

int min_lvl = rs. (3);

int max_lvl = rs. (4);

}

} catch (ClassNotFoundException e) {

e.printStackTrace();

} catch (SQLException e) {

e.printStackTrace();

}

展开