conn.jsp

自己编写的jsp+mysql论坛系统,带后台系统.不是很完善,但是功能是完整的

<%
	request.setCharacterEncoding("GBK");
%>
<%
	String driverName = "com.mysql.jdbc.Driver";
	String userName = "root";
	String userPasswd = "123456";
	String dbName = "mpgbbs";//db
	String tuinfo = "userinfo";//userinfo
	String tadmin = "admininfo";//admininfo
	String tbbs = "bbsinfo";//BBSinfo
	String treply = "bbsreplyinfo";//BBSreplyinfo
	Connection conn;
	Statement stmt;
	ResultSet rs;
	PreparedStatement pstmt;
		String url = "jdbc:mysql://localhost/" + dbName + "?user="
				+ userName + "&password=" + userPasswd
				+ "&useUnicode=true&characterEncoding=GBK";
		//Class.forName("org.gjt.mm.mysql.Driver").newInstance();
		Class.forName("com.mysql.jdbc.Driver").newInstance();
		conn = DriverManager.getConnection(url);
		stmt = conn.createStatement();
%>