MySQL 5.1.5 驱动在JSP中怎么安装

0尾肥牛 2023-03-17 21:45

• 

  _Anemone_

  2023-03-17 22:22

  在eclipse里新建工程，然后把mysql-connector-java-5.1.5.jar包拷贝到Webroot>WEB-INF>lib目录下。然后新建一个类，(也可以直接在jsp页面写)package com;import java.sql.*;public class ConnMysql { public ConnMysql() { super(); } private static ConnMysql instance = null; //获得连接 public static synchronized Connection my_getConnection(){ if (instance == null) { instance = new ConnMysql(); } return instance.me_getConnection(); } //获得连接所需要的属性数据等值 private Connection me_getConnection(){ try { Class.forName("com.mysql.jdbc.Driver").newInstance(); String url ="jdbc:mysql://localhost:3306/数据库名?user=用户名&password=密码&useUnicode=true&characterEncoding=GB2312"; return DriverManager.getConnection(url); } catch (Exception ex) { System.out.print(ex.getMessage()); return null; } }}在jsp页面中<%@page import="java.sql.*" %><%@page import="com.ConnMysql" %><% Connection con = null; Statement s = null; ResultSet rs = null ; con =ConnMysql.my_getConnection(); try{ s = con.createStatement(); }catch(Exception e){ System.out.print("statement error!"); }%><% // rs = s.executeQuery("SELECT * FROM ...");%>
  0 讨论(0)
  发布评论:

  提交评论

  ---

  •  加载中...