conn.jsp

来自「适合初学jsp的通讯录」· JSP 代码 · 共 30 行

<%@ page import="java.sql.*"%>
<%
	String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
	String sConnStr = "jdbc:odbc:txl";/*驱动*/
	String user = "admin";  /*用*/
    String password = "admin";   /**/
	Connection connect = null;
	int count = 0;
	try 
	{
		Class.forName(sDBDriver);
	}
	catch(java.lang.ClassNotFoundException e)
	{
		System.err.println( e.getMessage());
	}

	Connection conn = null; 
	Statement stmt = null;
	ResultSet rs=null;
	try 
	{ 
		conn = DriverManager.getConnection(sConnStr,user,password); 
		stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE ,ResultSet.CONCUR_READ_ONLY  ) ;
	} 
	catch(SQLException ex) 
	{ 
		System.err.println("aq.executeQuery: " + ex.getMessage()); 
	}%>