servlet到mysql数据库连接_servlet连接mysql数据库

// 从HttpServlet继承, 并只粘贴了doGet()方法, doPost()方法, 按照servlet实现方法写即可.

public void doGet(HttpServletRequest req, HttpServletResponse res){ String url = “jdbc:mysql://localhost:3306/jytest”; // jytest为mysql里面的数据库名称 Connection con = null; Statement stat = null; ResultSet rs = null; res.setContentType(“text/html;charset=gbk”); // 为解决打印出来的中文乱码 try{ PrintWriter pw = res.getWriter(); try{ // Class.forName(“org.gjt.mm.mysql.Driver”).newInstance(); Class.forName(“com.mysql.jdbc.Driver”); pw.println(“mysql 驱动程序已加载 …”); } catch (Exception ex){ pw.println(“无法加载mysql驱动程序” + ex.getMessage()); return; } try{

// root为mysql用户名, 123456为密码 con = DriverManager.getConnection(url, “root”, “123456″); stat = con.createStatement(); String sqlString = “select * from a”; rs = stat.executeQuery(sqlString); while (rs.next()){

// rs.getString(1), rs.getString(2)为a表中的两个字段 pw.println(rs.getString(1) + ” ” + rs.getString(2)); } rs.close(); stat.close(); con.close(); } catch (SQLException ex){ while (ex != null){ ex.printStackTrace(pw); ex = ex.getNextException(); } } } catch (Exception ex){ ex.printStackTrace(); } }