conn.jsp

来自「该程序由纯jsp实现」· JSP 代码 · 共 20 行

<%--
  Created by IntelliJ IDEA.
  User: vm
  Date: 2008-6-9
  Time: 19:43:03
  To change this template use File | Settings | File Templates.
--%>
<%
String host="localhost";
String user="root";  //用户名
String pw="";  //密码
String db="txl";   //数据库名
Class.forName("com.mysql.jdbc.Driver").newInstance();
String url="jdbc:mysql://"+host+"/"+db;
//java.sql.DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
//String url = "jdbc:oracle:thin:@" + host + ":1521:opencms";
Connection con=DriverManager.getConnection(url,user,pw);
Statement st=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
Statement st1=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
%>