jsp访问操作mysql数据库

    项目推进到需要使用jsp访问服务器端mysql数据库，此篇文章实现方法为jdbc驱动方式连接。

    需要注意的是，在部署在服务器端tomcat/webapps文件夹下前，需要在tomcat安装目录的lib文件夹下放入连接mysql的jdbc驱动，驱动下载：http://download.youkuaiyun.com/detail/qq_26071477/9662841

    给出连接mysql数据库的代码，包括基础的查询、更改、删除，其他功能实现类似，可自主查询。

<%@ page contentType="text/html;charset=UTF-8" language="java"%>
<%@ page language="java"%>
<%@ page import="com.mysql.jdbc.Driver"%>
<%@ page import="java.sql.*"%>
<%
	String driverName = "com.mysql.jdbc.Driver";
	String userName = "***";//数据库名
	String userPasswd = "****";//数据库密码
	String dbName = "test";
	String tableName = "USER";
	String url = "jdbc:mysql://localhost/" + dbName + "?user="
			+ userName + "&password=" + userPasswd;
	Class.forName("com.mysql.jdbc.Driver").newInstance();
	Connection connection = DriverManager.getConnection(url);
	Statement statement = connection.createStatement();
	
	String sql = "SELECT * FROM " + tableName;
	ResultSet rs ;
	rs = statement.executeQuery(sql);
	ResultSetMetaData rmeta = rs.getMetaData();
	int numColumns = rmeta.getColumnCount();
	//打印原来的数据
	out.print("原来的数据是：<br>");
	out.print("user");
	out.print("|");
	out.print("userpwd");
	out.print("<br>");
	//rs = statement.executeQuery(sql);
	while (rs.next()) 
	{
		out.print(rs.getString(1) + " ");
		out.print(rs.getString(2) + " ");
		out.print("<br>");
	}
	
	
	//更新语句
	out.print("数据更新！！");
	String tiqian = "SET SQL_SAFE_UPDATES = 0;";
	String updatesql = "update USER set userpwd='updatepwd' where username='user1'";//
	statement.execute(tiqian);
	statement.executeUpdate(updatesql);
	out.print("数据更新成功！！");
	out.print("<br>");
	
	//打印更新后的数据
	rs = statement.executeQuery(sql);
	out.print("更新后的数据是：<br>");
	out.print("user");
	out.print("|");
	out.print("userpwd");
	out.print("<br>");
	while (rs.next()) 
	{
		out.print(rs.getString(1) + " ");
		out.print(rs.getString(2) + " ");
		out.print("<br>");
	}
	

	//删除语句
	String deletesql="delete from USER where username='user1'";
	statement.executeUpdate(deletesql);
	out.print("数据删除成功！！");
	out.print("<br>");
	
	//打印删除后的数据
	rs = statement.executeQuery(sql);
    rmeta = rs.getMetaData();
	numColumns = rmeta.getColumnCount();
	out.print("user");
	out.print("|");
	out.print("userpwd");
	out.print("<br>");

	while (rs.next()) {

		out.print(rs.getString(1) + " ");
		out.print(rs.getString(2) + " ");
		out.print("<br>");

	}
	out.print("<br>");
	rs.close();
	statement.close();
	connection.close();
%>

    测试截图如下：

    特记下，以备后日回顾。