Çë½ÌjspÖÐÏÂÀÁбíµÄ¶¯Ì¬²éѯ - Java / Web ¿ª·¢
ÏÂÀÁбíÖеÄÖµÊÇ´ÓÊý¾Ý¿âÖеõ½µÄ£¬ÔõÑùʵÏÖÈ¡µ½ÏÂÀÁбíµÄÖµ²¢²éѯÊý¾Ý¿â
sqlÓï¾ä£ºString sql="select * from xiaofei where regname like '%"+userid+"%' and xfdate=´ÓÏÂÀÁбíÖÐÈ¡µÃµÄÖµ";
selectµÄÓï¾ä£º
<form name="form" method="post">
<div align="center">
<table width="959" height="524" border="0">
<tr>
<td height="37" colspan="6" align="right"><div align="center">ÇëÑ¡Ôñ
</div>
<label>
<div align="center">
<select name="aaa" id="aaa" onChange="disSel();">
<%
request.setCharacterEncoding("gb2312");
String strError = null;
String userid=(String)session.getAttribute("user");
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc:odbc:goodschaginfo");
Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
String sql="select distinct xfdate from xiaofei where regname like '%"+userid+"%' order by xfdate
Ïà¹ØÎÊ´ð£º
insert into [ScholarshipManagement].[dbo].[department] ([department],[specialization] ,[grade]) output inserted.departmentID values(? ,? ,? )
ÇëÎÊ´ó¸çÃÇÕâ¸ösql Óï¾äÓ¦¸ÃÓÃJavaÀïµÄÄǸöÊý¾Ý¿â²Ù×÷·½·¨£¿ ......
ÔھƵê¹ÜÀíϵͳÖÐ,ÓÐÒ»¸ö¶ÔÄÚµÄϵͳ,¹©Ç°Ì¨·þÎñÔ±ºÍ¾ÀíʹÓÃ
»¹ÓÐÒ»¸ö¾ÍÊǶÔÍâ,Èÿͻ§¿ÉÒÔÔÚÍøÉÏÔ¤¶©·¿¼ä,
ËüÃÇÖ®¼äÊÇÔõôͨѶµÄ.?µ±ÎÒÌá½»Ô¤¶©·¿¼äÐÅÏ¢µÄʱºò,
ÔÚ¶ÔÄÚµÄϵͳÖÐ,ÈçºÎÖªµÀÎÒÒѾÌá½»ÁËÐÅÏ¢¹ýÈ¥.Ê¹Ç ......
ÎÒдÁ˸öjspÒ³Ãæ£¬È»ºó¸Ä¶¯ÁËһϣ¬¸Ä¶¯µÄÄÚÈݾÍÊÇÔÚjspÒ³ÃæµÄjsº¯ÊýÀï¼ÓÁ˸öalert()Óï¾ä£¬µ«ÊÇÎÒ·ÃÎÊÕâ¸öÒ³ÃæÊ±£¬ËÀ»î¶¼ÊÇÔÀ´Ò³ÃæµÄÄÚÈÝ£¬ÎÒ¼ÓÁ˺ܶàalertº¯Êý»¹ÊÇû¸Ä¶¯Ç°µÄÒ³ÃæÄÚÈÝ£»tomcatÖØÆôÁË£¬Ò²ÖØÐ²¿ÊðÕâ ......