Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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


Ïà¹ØÎĵµ£º

jsp URI´«µÝ²ÎÊý£¬¶Ô·½½ÓÊÜÊÇÂÒÂë½â¾ö·½·¨

ÕâÖ÷ÒªÊÇtomcatµÄÎÊÌ⣬Ëü»áÔÚ´«Ë͵Äʱºò°Ñ×Ö·û¼¯ÖØÐ±àÒ룬µÈ´«¹ýÈ¥µÄjspÒ³Ãæ½ÓÊܵÄʱºò¾Í»á³öÏÖÂÒÂ룬
²»¹ÜÔÚÒ³ÃæÀïÈçºÎÉèÖÃ×Ö·û¼¯¶¼Ã»°ì·¨½â¾ö£¬Õâʱºò±ØÐë±ØÐëÔÚtomcat°²×°Ä¿Â¼Àï½øÐÐÉèÖã¬
C:\Program Files\apache-tomcat-6.0.14\confĿ¼Ï server.xmlÏ <Connector/>±êǩϠ¼ÓÒ»¾ä URIEncoding="GBK" ¾ÍºÃÁ ......

jsp:forward±êÇ©ºÍresponse.sendRedirect()·½·¨µÄÇø±ð

ÔÚÍøÉÏ¿´µ½Ò»Ð©Ìû×Ó£¬×ܽáÁËÒ»Ð©Çø±ð£¬¿ÉÒÔ´ÓÒÔϼ¸¸ö·½ÃæÀ´¿´£º
1.´ÓµØÖ·À¸ÏÔʾÀ´Ëµ
forwardÊÇ·þÎñÆ÷ÇëÇó×ÊÔ´,·þÎñÆ÷Ö±½Ó·ÃÎÊÄ¿±êµØÖ·µÄURL,°ÑÄǸöURLµÄÏìÓ¦ÄÚÈݶÁÈ¡¹ýÀ´,È»ºó°ÑÕâЩÄÚÈÝ
ÔÙ·¢¸øä¯ÀÀÆ÷.ä¯ÀÀÆ÷¸ù±¾²»ÖªµÀ·þÎñÆ÷·¢Ë͵ÄÄÚÈÝ´ÓÄÄÀïÀ´µÄ,ËùÒÔËüµÄµØÖ·À¸»¹ÊÇÔ­À´µÄµØÖ·.
redirectÊÇ·þÎñ¶Ë¸ù¾ÝÂß¼­,·¢ËÍÒ»¸ö×´ ......

jspµ÷Óô洢¹ý³Ì

  ÔÚsql2000Öд´½¨´æ´¢¹ý³Ì£º
--ÇóÁ½ÊýÖ®ºÍ
create proc up_sum @a int ,@b int ,@result int output
as
select @result= @a+@b
µ÷Ó÷½·¨£º
...
CallableStatement cstmt=con.prepareCall("exec  up_sum ?,?,?");
cstmt.registerOutParameter(3,java.sql.Types.INTEGER);
    &nb ......

JSP±àÂ볣ʶ[ת]

GBK±àÂë
GBK±àÂëÊÇÖйúÖÆ¶©µÄ¡¢µÈͬÓÚUCSµÄеÄÖÐÎıàÂëÀ©Õ¹¹ú¼Ò±ê×¼¡£GBK¹¤×÷С×éÓÚ1995Äê10Ô£¬Í¬Äê12ÔÂÍê³ÉGBK¹æ·¶¡£¸Ã±àÂë±ê×¼¼æÈÝGB2312£¬¹²ÊÕ¼ºº×Ö21003¸ö¡¢·ûºÅ883¸ö£¬²¢Ìṩ1894¸öÔì×ÖÂë룬¼ò¡¢·±Ìå×ÖÈÚÓÚÒ»¿â¡£
UTF-8±àÂë
UTF-8±àÂë¿ÉÒÔͨ¹ýÆÁ±ÎλºÍÒÆÎ»²Ù×÷¿ìËÙ¶Áд¡£×Ö·û´®±È½Ïʱstrcmp()ºÍwcscmp()µÄ·µ»Ø½ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ