想要jsp连数据库的代码吧,如下:
---------------------------------------------------------------
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
String sConnStr="jdbc:mysql://211.92.175.138/BIS_DB?user=root&password=12345";
Connection sqlCon = DriverManager.getConnection(sConnStr); 
Statement sqlStmt = sqlCon.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
String strSql="select * from tab";
ResultSet sqlRst = sqlStmt.executeQuery(strSql);
while(sqlRst.next()) {
//out.write("<a>" + sqlRst.getString(0) + "</a>");
}
---------------------------------------------------------------
具体的业务逻辑自己去写吧