JSP連接配接MySQL資料庫問題JSP連接配接MySQL資料庫問題

marginwidth="0" marginheight="0" src="http://creative.unionsys.bolaa.com/?daty=1&sp=1&pu=9606&agmt=73&da=464" frame width="760" scrolling="no" height="80">

marginwidth="0" marginheight="0" src="http://creative.unionsys.bolaa.com/?daty=1&sp=1&pu=9606&agmt=71&da=446" frame width="760" scrolling="no" height="115">

marginwidth="0" marginheight="0" src="http://creative.unionsys.bolaa.com/?daty=1&sp=1&pu=9606&agmt=68&da=392" frame width="760" scrolling="no" height="115">

?

JSP杩???ySQL?版??搴???棰?

?

褰??ㄩ??複JSP杩???ySQL?版??搴???棰?,浣?棣?????瑕???ySQL?版??搴?????寤轟?username琛??琛ㄩ???㈠??寤轟袱涓?瀛?绗?????瀛?娈碉?瀛?娈靛??????涓猴?uid锛?pwd锛??跺?????ュ???℃?璇??版????

?

浠ヤ??ㄤ袱绉??瑰??ュ????SP杩???ySql ?版??搴?

?

绗?涓?绉??瑰?锛???JSP 瀹???

?

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*"%> <meta http-equiv="Content-Type" content="text/html; charset=gb2312"> <%//******************************* **************** JDBC_ODBC杩???ySql?版??搴?锛?涓???瑕?璁劇疆?版??婧?*********** **********************/ //********** ?版??搴?杩??ヤ唬????寮?濮? ******/ //浠ヤ???椤矽?瘋??琛?淇???tring server="localhost"; //MYSQL ???″?ㄧ???闆??String dbname="test"; //MYSQL ?版??搴?????瀛?String user="root"; //MYSQL ?版??搴????誨??ㄦ?峰??String pass="chfanwsp"; //MYSQL ?版??搴????誨?瀵???String port="3306"; //SQL Server ???″?ㄧ??绔??ｅ?鳳? 榛?璁や負1433//?版??搴?杩??ュ??绗?覆 String url ="jdbc:mysql://"+server+":"+port+"/"+dbname+"? user="+user+"&passWord="+pass+"&useUnicode =true&characterEncoding=GB2312"; //??杞介┍?ㄧ?搴?Class.forName("org.gjt.mm.mysql.Driver").newInstance(); //寤虹??杩???onnection conn= DriverManager.getConnection(url); //??寤鴻???ュ?矽薄Statement stmt=conn.createStatement (ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE); // **** ?版??搴?杩??ヤ唬????缁??? ******* String sql="select * from username"; ResultSet rs=stmt.executeQuery(sql); //rs.first();while(rs.next()){out.print("?ㄦ?峰??:"); out.print(rs.getString("uid")+" 瀵???:"); out.println(rs.getString("pwd")+"<br>");} rs.close();stmt.close();conn.close();%>

?

绗?浜?绉??瑰?锛???avaBean?ュ???幫?

?

DBConnMySql.java缂?璇?浠ュ????Class??浠跺?璇ユ?懼??eb-INF/classes/conn ??褰? 涓???

?

package conn; //瀵煎?ュ??import java.sql.*; //瀵煎?ユ?版??搴???浣???绫?ublic class DBConnMySql //?????規?锛???濮???{private Connection conn; //杩??ュ?矽薄private Statement stmt; //璇??ュ?矽薄private ResultSet rs; //缁?????瀵矽薄private String MySqldriver; //MYSQL Server椹卞?ㄧ?搴?瀛?绗?覆private String MySqlURL; //MYSQL Server杩??ュ??绗?覆//********************************* ?? org.gjt.mm.mysql.Driver 椹卞?? * 璇ユ?規???寰?杩??ユ??????绉????幫?缁???杩??ュ??绗?覆锛? ?跺????寤虹??杩??? server;dbname,user,pass,port ????琛ㄧずMYSQL ???″?ㄧ???闆??锛? * ?版??搴?锛??ㄦ?峰??锛?瀵???锛?绔???**********************************/ public Connection getConnToMySql (String server,String dbname,String user,String pass,String port) {//MYSQl椹卞?ㄧ?搴?MySqldriver = "org.gjt.mm.mysql.Driver"; MySqlURL = "jdbc:mysql://"; //杩??ュ??绗?覆涓??ㄥ??try{//瀹??寸??杩??ュ??绗?覆MySqlURL =MySqlURL+server+":"+port+"/"+dbname+"?user= "+user+"&password="+pass+"&useUnicode =true&characterEncoding=GB2312"; Class.forName(MySqldriver);conn = DriverManager.getConnection(MySqlURL);} catch(Exception e){System.out.println ("??浣??版??搴??洪??锛?璇蜂?缁?妫???); //System.err.println(e.getMessage());}return conn;} //?抽???版??搴?杩???ublic void close(){try{//rs.close(); //stmt.close();conn.close();}catch(SQLException sqlexception){sqlexception.printStackTrace();}}}

?

杩?涓???浠跺????瀹??頒? ?版?? 搴???杩??ワ?涓??㈠????涓?涓?娴?璇???浠?灏辨????QL璇??ヤ??版??搴????ヨ?㈠?鴻?闆?锛?浠ラ??璇???浠??版??搴???杩??ユ??????????

?

connmysql.jsp??浠舵?浠ｇ??濡?涓?锛?

?

<meta http-equiv="Content-Type" content="text/html; charset=gb2312"><%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" %> <jsp:useBean id="DBConn" scope="page" class="conn.DBConnMySql"/> <% //浠ヤ???椤矽?瘋??琛?淇???tring server="localhost"; //MYSQL ???″?ㄧ???闆??String dbname="test"; //MYSQL ?版??搴?????瀛?String user="root"; //MYSQL ?版??搴????誨??ㄦ?峰??String pass="chfanwsp"; //MYSQL ?版??搴????誨?瀵???String port="3306"; //SQL Server ???″?ㄧ??绔??ｅ?鳳?榛?璁や負1433Connection conn=DBConn.getConnToMySql (server,dbname,user,pass,port); Statement stmt=conn.createStatement (ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY); String sql="select * from username"; String sql1="insert into username (uid,pwd) values ('姊??沖勾??','姊??沖勾??')";stmt.executeUpdate(sql1); ResultSet rs=stmt.executeQuery(sql);while(rs.next()) {out.print("?ㄦ?峰??:");out.print(rs.getString("uid")+" 瀵???:"); out.println(rs.getString("pwd")+"<br>");} //rs.close();//stmt.close();//conn.close();DBConn.close();%>

?

marginwidth="0" marginheight="0" src="http://creative.unionsys.bolaa.com/?daty=1&sp=1&pu=9606&agmt=70&da=442" frame width="760" scrolling="no" height="115">

<script>var ally263_id='26636';var ally263_no='a0a0'; var ally263_width='760';var ally263_height='120';</script><script src=' http://ally.263.net/user/ally.js'></script>