学生信息管理MyEclipse软件用JSP连接MySQL对表中数据显示增加删除

package fanlaoshi; import java.sql.*; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Connection; import java.sql.Statement; import java.io.*; public class TestJDBC { public static void main(String[] args) throws Exception { Connection con= null; try { Class.forName("com.mysql.jdbc.Driver"); con=DriverManager.getConnection("jdbc:mysql://localhost:3306/test" ,"root","123456"); Statement stmt = con.createStatement(); ResultSet rs = stmt.executeQuery("select * from user"); while (rs.next()) { String a = rs.getString("id"); System.out.print(rs.getString("name")); System.out.print(rs.getString("sex")); System.out.print(rs.getString("age")); System.out.print(rs.getString("diploma")); System.out.print(rs.getString("tel")); } rs.close(); stmt.close(); con.close(); } catch (Exception e) { System.out.println(e.getMessage()); } }}