sybase.txt

jsp与数据库开发的全部代码

Class.forName("com.sybase.jdbc.SybDriver").newInstance();
//datebase为所要连接的数据库名
String url =" jdbc:sybase:Tds:localhost:5007/datebase";
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);
//取出test表内的所有字段
String sql="select * from test";
//执行sql语句
ResultSet rs=stmt.executeQuery(sql);