conn.jsp

来自「本人用ＪＳＰ编写的一个网站程序」· JSP 代码 · 共 36 行

<% 
String sDBDriver = "com.mysql.jdbc.Driver";
String username = "cen-link";
String pass = "060723";
//String sConnStr = "jdbc:mysql://unixj1-db-g01/db_cen-link_com?user="+username+"&password="+pass+"&useUnicode=true&characterEncoding=gb2312";
String sConnStr = "jdbc:mysql://localhost/cen-link?user="+username+"&password="+pass+"";

java.sql.Connection conn = null;
java.sql.Statement stmt = null;
java.sql.ResultSet rs=null; 

try 
{ 
	Class.forName(sDBDriver).newInstance(); 

}
catch(java.lang.ClassNotFoundException e)
{
	out.print("Connect to Database error: " + e.getMessage());
}
try
{
	conn = java.sql.DriverManager.getConnection(sConnStr);
	stmt=conn.createStatement(java.sql.ResultSet.TYPE_SCROLL_SENSITIVE,java.sql.ResultSet.CONCUR_UPDATABLE); 

 
}
catch(Exception e)
{
	out.print(e.toString());
}

%>