：<%@pagecontentType="text/html;charset=GB2312"%><%@pageimport="java.sql.*"%><HTML><HEAD><TITLE>JSP测试SYBASEjconnect-5_2JDBC数据库接口</TITLE><METANAME="Generator"CONTENT="EditPlus2.11"><METANAME="Author"CONTENT="naxin"></HEAD><BODY><center>JSP测试SYBASEjconnect-5_2JDBC数据库接口</center><BR><BR><tableborder=3align=center><%Class.forName("com.sybase.jdbc2.jdbc.SybDriver");Stringurl="jdbc:sybase:Tds:localhost:2638";Connectionconn=DriverManager.getConnection(url,"dba","sql");Statementstmt=conn.createStatement();Stringsql="selectemp_lname,dept_id,street,city,statefromemployeeorderbyemp_lname";ResultSetrs=stmt.executeQuery(sql);while(rs.next()){out.print("<TR><TD>"+rs.getString("emp_lname")+"</TD>");out.print("<TD>"+rs.getString("dept_id")+"</TD>");out.print("<TD>"+rs.getString("street")+"</TD>");out.print("<TD>"+rs.getString("city")+"</TD>");out.print("<TD>"+rs.getString("state")+"</TD></TR>");}%></table><BR><HR><%out.print("数据库操作成功，恭喜你");%><%rs.close();stmt.close();conn.close();%></BODY></HTML>
|
2.再用JSP和JavaBean的方法:
JSPCode:<%@pagecontentType="text/html;charset=GB2312"%><%@pageimport="java.sql.*"%><HTML><HEAD><TITLE></TITLE><METANAME="Generator"CONTENT="EditPlus2.11"><METANAME="Author"CONTENT="naxin"></HEAD><BODY><jsp:useBeanid="sybase"scope="page"class="test.sybconn"/><%ResultSetrs=sybase.Query("select*fromtjck_dh");while(rs.next()){out.print("|"+rs.getString("name")+"|");out.print(rs.getString("card_no")+"|");out.print(rs.getString("amount")+"|");out.print(rs.getString("home_call")+"|");out.print(rs.getString("office_call")+"|<br>");}rs.close();%><HR>Bean的代码:packagetest;importjava.sql.*;publicclasssybconn{//StringsDBDriver="com.sybase.jdbc2.jdbc.SybDriver";StringsConnStr="jdbc:sybase:Tds:localhost:2638";//Stringuser="dba";//Stringpasswd="sql";Connectionconn=null;ResultSetrs=null;publicResultSetQuery(Stringsql)throwsSQLException,Exception{Class.forName("com.sybase.jdbc2.jdbc.SybDriver").newInstance();conn=DriverManager.getConnection(sConnStr,"dba","sql");Statementstmt=conn.createStatement();rs=stmt.executeQuery(sql);returnrs;}}
|
3.利用JDBC(SYBAEjconnect-5_2)查询SybaseASA7.0中数据的图形化Java程序范例:
////一个简单的利用JDBC(SYBAEjconnect-5_2)查询SybaseASA7.0中数据的图形化Java程序范例//执行的SQL语句是"select*fromemployee",可以改成自己所需的.//运行方式为:c:\>javaJDBCTest//importjava.awt.*;importjava.sql.*;//在使用JDBC之前，必须引入JAVA的SQL包classJDBCTestextendsFrame{TextAreamyTextArea;publicJDBCTest(){//设定程序的显示界面super("一个简单的利用JDBC(jconnect-5_2)查询SybaseASA7.0中数据的图形化Java程序范例");setLayout(newFlowLayout());myTextArea=newTextArea(30,80);add(myTextArea);resize(500,500);show();myTextArea.appendText("数据库查询中，请等待......\n");}voiddisplayResults(ResultSetresults)throwsSQLException{//首先得到查询结果的信息ResultSetMetaDataresultsMetaData=results.getMetaData();intcols=resultsMetaData.getColumnCount();//将等待信息清除myTextArea.setText("");//显示结果while(results.next()){for(inti=1;i<=cols;i++){if(i>1)myTextArea.appendText("\t");try{myTextArea.appendText(results.getString(i));}//捕获空值时产生的异常catch(NullPointerExceptione){}}myTextArea.appendText("\n");}}publicbooleanhandleEvent(Eventevt){if(evt.id==Event.WINDOW_DESTROY){System.exit(0);returntrue;}returnsuper.handleEvent(evt);}publicstaticvoidmain(Stringargv[])throwsSQLException,Exception{//设定查询字串StringqueryString="select*fromemployee";JDBCTestmyJDBCTest=newJDBCTest();//加载驱动程序Class.forName("com.sybase.jdbc2.jdbc.SybDriver").newInstance();//建立连接,localhost为主机名,dba为用户名，sql为密码ConnectionmyConn=DriverManager.getConnection("jdbc:sybase:Tds:localhost:2638","dba","sql");StatementmyStmt=myConn.createStatement();//执行查询ResultSetmyResults=myStmt.executeQuery(queryString);myJDBCTest.displayResults(myResults);//关闭所有打开的资源myResults.close();myStmt.close();myConn.close();}}
|
