JSPʵÀýÒ»¡¢¹ºÎï³µ

֪ʶ׼±¸£º
JDBC·ÃÎÊÊý¾Ý¿âµÄ»ù±¾²½Öè
£¨1£©¡¢½«Êý¾Ý¿âµÄJDBCÇý¶¯¼ÓÔص½¹¤³ÌÀà¿âÖС£
£¨2£©¡¢¼ÓÔØJDBCÇý¶¯£¬²¢½«Æä×¢²áµ½DriverManagerÖС£ÏÂÃæÊÇһЩÖ÷Á÷Êý¾Ý¿âµÄJDBCÇý¶¯¼ÓÔØ×¢²áÂ룺
¢Ù¡¢oracleÊý¾Ý¿â
Class.forName(“oracle.jdbc.driver.OracleDriver”).newInstance();
¢Ú¡¢Sql Server 7.0/2000Êý¾Ý¿â
Class.forName(“com.microsoft.jdbc.sqlserver.SQLServerDriver”).newInstance();
¢Û¡¢MySQLÊý¾Ý¿â
Class.forName(“com.mysql.jdbc.Driver”).newInstance();
(3)¡¢½¨Á¢Êý¾Ý¿âÁ¬½Ó£¬È¡µÃConnection¶ÔÏó¡£
¢Ù¡¢oracleÊý¾Ý¿â
String url=”jdbc:oracle:thin:@localhost:1521:orcl”;
String user=”scott”:
String password=”tiger”;
Connetion conn=DriverManager.getConnetion(url,user,password);
¢Ú¡¢Sql Server 7.0/2000Êý¾Ý¿â
String url=”jdbc:microsoft:sqlserver://localhost:1443;DatabaseName=pubs”;
String user=”sa”;
String password=””;
Connection conn=DriverManager.getConnection(url,user,password);
¢Û¡¢MySQLÊý¾Ý¿â
String url=”jdbc:mysql://localhost:3306/testDB?user=root&password=root&
useUnicode=true&charaterEncoding=gb2312”;
Connection conn=DriverManager.getConnection(url);
(4)¡¢½¨Á¢Statement¶ÔÏó»òPreparedStatement¶ÔÏó¡£
//½¨Á¢Statement¶ÔÏó
Statement stmt=conn.createStatement();
//½¨Á¢PreparedStatement¶ÔÏó
String sql=”select *from users where userName=? And password=?”;
PreparedStatement pstmt=conn.prepareStatement(sql);
pstmt.setString(1,”admin”);
pstmt.setString(2,”liubin”);
(5)¡¢Ö´ÐÐSQLÓï¾ä¡£
//Ö´Ðо²Ì¬SQL²éѯ
String sql=”select * from users”;
ResultSet rs = stmt.executeQuery(sql);
//Ö´ÐÐinsert¡¢update¡¢deleteµÈÓï¾ä£¬Ïȶ¨Òåsql
Stmt.executeUpdate(sql);
(6)¡¢·ÃÎʽá¹û¼Ç¼¼¯ResultSet¶ÔÏó¡£
While(rs.next())
{
    out.println(“ÄãµÄµÚÒ»¸ö×Ö¶ÎÄÚÈÝΪ£º“+rs.getString(1));
    out.println(“ÄãµÄµÚ¶þ¸ö×Ö¶ÎÄÚÈÝΪ£º“+rs.getString(2));
}
(7)¡¢ÒÀ´Î½«ResultSe