jspstudy 升级mysql_jspstudy+myeclipse 搭建jsp开发环境

修改index.jsp添加以下代码

//驱动程序名

String driverName="com.mysql.jdbc.Driver";

//数据库用户名

String userName="root";

//密码

String userPasswd="root";

//数据库名

String dbName="testdb";

//表名

String tableName="student";

//联结字符串

String url="jdbc:mysql://127.0.0.1/"+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 = statement.executeQuery(sql);

//获得数据结果集合

ResultSetMetaData rmeta = rs.getMetaData();

//确定数据集的列数，亦字段数

int numColumns=rmeta.getColumnCount();

// 输出每一个数据值

out.print("id"+"      ");

out.print("name"+"      ");

out.print("age"+"      ");

out.print("gender"+"      ");

out.print("major"+"      ");

out.print("
");

while(rs.next()) {

out.print(rs.getString(1)+" ");

out.print(rs.getString(2)+" ");

out.print(rs.getString(3)+" ");

out.print(rs.getString(4)+" ");

out.print(rs.getString(5));

out.print("
");

}

out.print("
");

out.print("数据库操作成功，恭喜你");

rs.close();

statement.close();

connection.close();

%>

然后将数据库驱动复制到工程下，右键驱动->build path