想要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>");
}
---------------------------------------------------------------
具体的业务逻辑自己去写吧
---------------------------------------------------------------
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>");
}
---------------------------------------------------------------
具体的业务逻辑自己去写吧
http://community.csdn.net/Expert/FAQ/FAQ_Index.asp?id=198771
我自己用数据库操作没用<srcipt>,每次点击都得刷一下页面.我按上面的例子做一个不刷的.呵呵.谢谢了..