JSP database connection
I. JSP connection Oracle8 / 8i / 9i database (with Thin mode) TestoCle.jsp as follows: <% @ page contenttype = "text / html; charset = GB2312"%> <% @ Page Import = "java.sql. *" %>
<% class.Forname ("Oracle.jdbc.driver.Oracledriver). NewInstance (); string url =" JDBC: Oracle: Thin: @localhost: 1521: ORCL "; // orcl SID String user to your database = "scott"; String password = "tiger"; Connection conn = DriverManager.getConnection (url, user, password); Statement stmt = conn.createStatement (ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE); String SQL = "Select * from test"; ResultSet RS = Stmt.executeQuery (SQL); while (rs.next ()) {%> Your first field content is: <% = rs.getstring (1)% > Your second field content is: <% = rs.getstring (2)%> <%}%> <% out.print ("Database operation success, congratulations");%> <% rs.close ); stmt.close (); conn.close ();%> body> html> 2, JSP connection SQL Server7.0 / 2000 database TestsqlServer.jsp is as follows: <% @ page contenttype = "text / html CHARSET = GB2312 "%> <% @ page import =" java.sql. * "%> <% class.forname (" com.microsoft.jdbc.sqlser.sqlserverdriver). NewInStance () ST Ring URL = "JDBC: Microsoft: SQLServer: // localhost: 1433; databasename = pubs"; // Pubs for your database String user = "sa"; string password = ""; connection conn = drivermanager.getconnection (URL , user, password); Statement stmt = conn.createStatement (ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE); String sql = "select * from test"; ResultSet rs = stmt.executeQuery (sql);While (rs.next ()) {%> Your first field content is: <% = rs.getstring (1)%> Your second field content is: <% = rs.getstring (2)% > <%}%> <% out.print ("Database operation is successful, congratulations");%> <% rs.close (); stmt.close (); conn.close ();%> body> html> Third, JSP connection DB2 database TESTDB2.JSP as follows: <% @ Page ContentType = "text / html; charset = GB2312"%> <% @ Page Import = "java.sql. *"%>
<% class.Forname ("com.ibm.db2.jdbc.app.db2driver") .newinstance (); string url = "jdbc: db2: // localhost: 5000 / sample"; // Sample for you the database name String user = "admin"; String password = ""; Connection conn = DriverManager.getConnection (url, user, password); Statement stmt = conn.createStatement (ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE); String sql = " Select * from test "; ResultSet RS = stmt.executeQuery (SQL); while (rs.next ()) {%> Your first field content is: <% = rs.getstring (1)%> Your The two fields are: <% = rs.getstring (2)%> <%}%> <% out.print ("Database operation success, congratulations");%> <% rs.close (); STMT. Close (); conn.close ();%> body> html> four, JSP connection Informix database Testinformix.jsp is as follows: <% @ Page ContentType = "Text / HTML CHARSET = GB2312 "%> <% @ page import =" java.sql. * "%> <% class.Forname (" com.informix.jdbc.ifxdriver). NewInstance (); string url = "jdbc: informix-sqli: //123.45.67.89: 1533 / testDB: INFORMIXSERVER = myserver; user = testuser; password = testpassword"; // testDB name for your database Connection conn = DriverManager.getConnection (url);Statement stmt = conn.createStatement (ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE); String sql = "select * from test"; ResultSet rs = stmt.executeQuery (sql); while (rs.next ()) {%> Your first A field content is: <% = rs.getstring (1)%> Your second field content is: <% = rs.getstring (2)%> <%}%> <% out.print ("database Successful operation, congratulations ");%> <% rs.close (); stmt.close (); conn.close ();%> body> html> 5, JSP connection Sybase database TestMysql.jsp is as follows : <% @ Page contenttype = "text / html; charSet = GB2312"%> <% @ page import = "java.sql. *"%>
<% class.forname ("com.sybase) JDBC.SYBDRIVER "). NewInstance (); string url =" JDBC: Sybase: TDS: localhost: 5007 / tsdata "; // tsdata for your database name Properties Sysprops = System.getProperties (); sysprops.put (" User "," userid "); SysProps.put (" password "," user_password "); Connection conn = DriverManager.getConnection (url, SysProps); Statement stmt = conn.createStatement (ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE); String sql = "SELECT * from test"; ResultSet RS = stmt.executeQuery (SQL); while (rs.next ()) {%> Your first field content is: <% = rs.getstring (1)%> Your second field content is: <% = rs.getstring (2)%> <%}%> <% out.print ("Database operation is successful, congratulations");%> <% rs.close (); stmt.close (); conn.close ();%> body> html> 6, JSP connection mysql database TestMysql The .jsp is as follows: <% @ page contenttype = "text / html; charset = GB2312"%> <% @ page import = "java.sql. *"%> <% class.forname ("