The code for connecting to the Sybase database instance Using jsp is as follows:
- <% @ Page contentType = "text/html; charset = gb2312" %>
- <% @ Page import = "java. SQL. *" %>
- <Html>
- <Body>
- <% Class. forName ("com. sybase. jdbc. SybDriver"). newInstance ();
- String url = "jdbc: sybase: TTL: localhost: 5007/tsdata ";
- // Tsdata is 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 rs1_stmt.exe cuteQuery (SQL );
- While (rs. next () {%>
- The content of your first field is: <% = rs. getString (1) %>
- Your second field content is: <% = rs. getString (2) %>
- <% }%>
- <% Out. print ("database operation successful, congratulations"); %>
- <% Rs. close ();
- Stmt. close ();
- Conn. close ();
- %>
- </Body>
- </Html>