如何用JDBC访问SQLServerl里面的数据裤(急,在线等) 具体功能如何在java中连接、打开和查询一个数据库。 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 二、jsp连接Sql Server7.0/2000数据库 testsqlserver.jsp如下: <%@ page contentType="text/html;charset=gb2312"%> <%@ page import="java.sql.*"%> <html> <body> <%Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance(); String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs"; //pubs为你的数据库的 String user="sa"; String password=""; Connection conn= DriverManager.getConnection(url,user,password); Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); String sql="select * from test"; ResultSet rs=stmt.executeQuery(sql); while(rs.next()) {%> 您的第一个字段内容为:<%=rs.getString(1)%> 您的第二个字段内容为:<%=rs.getString(2)%> <%}%> <%out.print("数据库操作成功,恭喜你");%> <%rs.close(); stmt.close(); conn.close(); %> </body> </html> 这是一个简单的连接sqlserver数据库的例子,你要写成java文件只需要把里面的连接以及其他执行的executeQuery以及executeUpdate等的操作封装在你设计的类中就可以那! import java.sql.*;public class conn{ private String userName=""; private String password=""; public conn(String userName,String password){ this.userName = userName; this.password = password; Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance(); Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=yourdb Connection conn= DriverManager.getConnection(url,user,password); String sql="select * from test"; do{ ResultSet rs=stmt.executeQuery(sql); }while(rs.next()) }}以上就是一个简单的连接类了!! 不好意思,刚才忘记贴程序了<%@ page language="java" contentType="text/html;charset=gb2312"%><%@ page import="java.sql.*"%><%@ page import="java.io.*"%><%@ page import="java.util.*"%><%@ page import="javax.naming.*"%><%/*Class.forName("com.internetcds.jdbc.tds.Driver").newInstance();String url="jdbc:freetds://server:1488/newXXFB";Connection con= DriverManager.getConnection(url,"qcc","qcc");Statement smt=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);ResultSet rs;String sql="select * from infomation";System.out.println(sql);rs=smt.executeQuery(sql); while (rs.next()){ System.out.println(rs.getString(1)); }*/ %><%//这是直接连接/*Driver myDriver =(Driver)Class.forName("weblogic.jdbc.mssqlserver4.Driver").newInstance();String driverURL = "jdbc:weblogic:mssqlserver4";Properties myProperties = new Properties();myProperties.put("server", "server:1488");myProperties.put("db", "newXXFB");myProperties.put("user", "qcc");myProperties.put("password", "qcc");Connection con =myDriver.connect(driverURL, myProperties);Statement smt=con.createStatement();ResultSet rs;String sql="select * from infomation";System.out.println(sql);rs=smt.executeQuery(sql); while (rs.next()){ System.out.println(rs.getString(1));}*/%><%//用连接池连接/*String driverName = "weblogic.jdbc.pool.Driver";Driver myDriver =(Driver)Class.forName(driverName).newInstance();String driverURL = "jdbc:weblogic:pool:sqlPool";Connection con =myDriver.connect(driverURL, null);Statement smt=con.createStatement();ResultSet rs;String sql="select * from infomation";System.out.println(sql);rs=smt.executeQuery(sql); while (rs.next()){ System.out.println(rs.getString(1));}*/%><%//用datasourcce连接数据库 javax.sql.DataSource myDS = null; Connection con=null; try { Context myContext = new InitialContext(); myDS = (javax.sql.DataSource) myContext.lookup("myDataSource"); } catch (NamingException e) { } try { con = myDS.getConnection(); } catch (SQLException e) { } Statement smt=con.createStatement(); ResultSet rs; String sql="select * from infomation"; System.out.println(sql); rs=smt.executeQuery(sql); while (rs.next()){ System.out.println(rs.getString(1)); } try{ con.close(); } catch (SQLException e) { System.out.println(e.getMessage()); }%> 面试时怎么介绍自己的项目啊?每次介绍时,都感觉无从下口?求解? 请问如何才能快速提取网页元素? java打印用PrintJob调出了的打印设置框无法加载默认的“纸张显示规格”,总是A4纸,如何处理,多谢 1500-2500 RMB求一功能实现,高手一日可搞掂 Sleep问题! 关于字符串数组 结果集的关闭问题! Eclipse运行输出“Hello world”小程序出错 体育彩票6+1选号程序大致成了。各位再提些意见。 为什么java的继承,在方法和成员变量两边表现不一样呢 java中的相对路径怎么写? 如何让java的应用程序支持鼠标中键
testsqlserver.jsp如下:
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<html>
<body>
<%Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs";
//pubs为你的数据库的
String user="sa";
String password="";
Connection conn= DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from test";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()) {%>
您的第一个字段内容为:<%=rs.getString(1)%>
您的第二个字段内容为:<%=rs.getString(2)%>
<%}%>
<%out.print("数据库操作成功,恭喜你");%>
<%rs.close();
stmt.close();
conn.close();
%>
</body>
</html>
这是一个简单的连接sqlserver数据库的例子,你要写成java文件只需要把里面的连接以及
其他执行的executeQuery以及executeUpdate等的操作封装在你设计的类中就可以那!
public class conn{
private String userName="";
private String password="";
public conn(String userName,String password){
this.userName = userName;
this.password = password;
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance(); Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=yourdb
Connection conn= DriverManager.getConnection(url,user,password);
String sql="select * from test";
do{
ResultSet rs=stmt.executeQuery(sql);
}while(rs.next())
}
}
以上就是一个简单的连接类了!!
<%@ page language="java" contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<%@ page import="java.io.*"%>
<%@ page import="java.util.*"%>
<%@ page import="javax.naming.*"%>
<%/*Class.forName("com.internetcds.jdbc.tds.Driver").newInstance();
String url="jdbc:freetds://server:1488/newXXFB";
Connection con= DriverManager.getConnection(url,"qcc","qcc");
Statement smt=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
ResultSet rs;String sql="select * from infomation";
System.out.println(sql);
rs=smt.executeQuery(sql);
while (rs.next()){
System.out.println(rs.getString(1));
}
*/
%>
<%
//这是直接连接
/*
Driver myDriver =(Driver)Class.forName("weblogic.jdbc.mssqlserver4.Driver").newInstance();String driverURL = "jdbc:weblogic:mssqlserver4";
Properties myProperties = new Properties();
myProperties.put("server", "server:1488");
myProperties.put("db", "newXXFB");
myProperties.put("user", "qcc");
myProperties.put("password", "qcc");
Connection con =myDriver.connect(driverURL, myProperties);
Statement smt=con.createStatement();
ResultSet rs;
String sql="select * from infomation";
System.out.println(sql);
rs=smt.executeQuery(sql);
while (rs.next()){
System.out.println(rs.getString(1));
}
*/
%>
<%//用连接池连接
/*
String driverName = "weblogic.jdbc.pool.Driver";
Driver myDriver =(Driver)Class.forName(driverName).newInstance();
String driverURL = "jdbc:weblogic:pool:sqlPool";
Connection con =myDriver.connect(driverURL, null);
Statement smt=con.createStatement();
ResultSet rs;
String sql="select * from infomation";
System.out.println(sql);
rs=smt.executeQuery(sql);
while (rs.next()){
System.out.println(rs.getString(1));
}*/%>
<%//用datasourcce连接数据库
javax.sql.DataSource myDS = null;
Connection con=null;
try {
Context myContext = new InitialContext();
myDS = (javax.sql.DataSource) myContext.lookup("myDataSource");
}
catch (NamingException e) {
}
try {
con = myDS.getConnection();
}
catch (SQLException e) {
}
Statement smt=con.createStatement();
ResultSet rs;
String sql="select * from infomation";
System.out.println(sql);
rs=smt.executeQuery(sql);
while (rs.next()){
System.out.println(rs.getString(1));
}
try{
con.close();
}
catch (SQLException e)
{ System.out.println(e.getMessage());
}
%>