Class.forName("com.mysql.jdbc.Driver");
String dsn="jdbc:mysql://localhost:3306/test_db?user=root&password=sa";
Connection conn=DriverManager.getConnection(dsn);
Statement cmd=conn.createStatement();
//新增数据
String sql = "select max(id) as num from employee";
ResultSet numRs = cmd.executeQuery(sql);
numRs.next();
int id = numRs.getInt(1) + 1;
sql = "insert into employee(id,last_name,first_name,birth,sex,email) values(" + id + ",'cc,'dd','1982-11-16','M','abc@cc.com')";
cmd.executeUpdate(sql);
//查询数据
ResultSet rs=cmd.executeQuery("select * from employee");
while(rs.next())
{
out.println(rs.getString(1) + "--" + rs.getString(2) + "--" + rs.getString(3)+ "--" + rs.getString(4)+ "--" + rs.getString(5)+ "--" + rs.getString(6));
out.println("<br/>");
Class.forName("com.mysql.jdbc.Driver");
String dsn="jdbc:mysql://localhost:3306/test_db?user=root&password=sa";
Connection conn=DriverManager.getConnection(dsn);
Statement cmd=conn.createStatement();
//新增数据
String sql = "select max(id) as num from employee";
ResultSet numRs = cmd.executeQuery(sql);
numRs.next();
int id = numRs.getInt(1) + 1;
sql = "insert into employee(id,last_name,first_name,birth,sex,email) values(" + id + ",'cc,'dd','1982-11-16','M','abc@cc.com')";
cmd.executeUpdate(sql);
//查询数据
ResultSet rs=cmd.executeQuery("select * from employee");
while(rs.next())
{
out.println(rs.getString(1) + "--" + rs.getString(2) + "--" + rs.getString(3)+ "--" + rs.getString(4)+ "--" + rs.getString(5)+ "--" + rs.getString(6));
out.println("<br/>");
}
cmd.close();
rs.close();
conn.close();
}
需下载连接数据驱动mysql-connector-java-5.1.0-bin.jar,这个文件可到站点基地下载,下载后将mysql-connector-java-5.1.0-bin.jar放置tomcat\webapps\ROOT\WEB-INF\lib目录下即可
下载附件:mysql-connector-java-5.1.0-bin.jar