jsp连接mysql需要引入一个jar包,下载地址:http://dev.mysql.com/downloads/connector/j/
解压后把mysql-connector-java-5.1.39-bin.jar导入到eclipse中
然后在拷贝一份到tomcat下的bin目录下
然后就可以测试增删改查了
pageEncoding="utf-8"%>
Insert title hereid | 用户名 | 密码 |
---|
Class.forName("com.mysql.jdbc.Driver");
String host = "jdbc:mysql://localhost:3306/demo?useUnicode=true&characterEncoding=utf-8" ;
String user = "root";
String pwd="";
Connection conn = DriverManager.getConnection(host, user, pwd);
Statement stmt = conn.createStatement();
int res = stmt.executeUpdate("INSERT INTO users(username,password)values('zhangsan','123456')");
out.println(res);
res = stmt.executeUpdate("UPDATE users set username='张三' where username='zhangsan'");
out.println(res);
res = stmt.executeUpdate("DELETE FROM users WHERE id=1");
out.println(res);
ResultSet rs = stmt.executeQuery("SELECT * FROM users");
while(rs.next()){
out.println("
"+rs.getString("id")+""+rs.getString("username")+""+rs.getString("password")+"");}
conn.close();
%>