//这是使用JDBC-ODBC桥驱动模式
import java.sql.*;
class JBDCTest
{
public static void main(String[] args)
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn = DriverManager.getConnection("jdbc:odbc:Ntserver","sa","2306");
System.out.println("数据库连接中....");
Statement stmt =conn.createStatement();
ResultSet results =stmt.executeQuery("select * from titles");
//int num=1;
while (results.next())
{
String titles =results.getString("title");
String prices =results.getString("price");
System.out.println("书名:"+titles+" 价格:"+prices);
}
System.out.println("连接关闭中...");
stmt.close();
conn.close();
}
catch (Exception e)
{
}
}
}Ntserver为数据源
import java.sql.*;
class JBDCTest
{
public static void main(String[] args)
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn = DriverManager.getConnection("jdbc:odbc:Ntserver","sa","2306");
System.out.println("数据库连接中....");
Statement stmt =conn.createStatement();
ResultSet results =stmt.executeQuery("select * from titles");
//int num=1;
while (results.next())
{
String titles =results.getString("title");
String prices =results.getString("price");
System.out.println("书名:"+titles+" 价格:"+prices);
}
System.out.println("连接关闭中...");
stmt.close();
conn.close();
}
catch (Exception e)
{
}
}
}Ntserver为数据源
解决方案 »
- JSP初学者求救:关于web项目如何导入myeclipse
- struts+hibernate如何将图片上传到服务器,路径保存到数据库中,而且将图片名字改为当前时间命名的?
- form 表单提交的时候 找不到页面??请教
- 利用jspsmartupload上载文件,如何判断用户指定的需要上载的文件路径不合法!
- 我怎样才能知道公司内部代理服务器的TCP/IP的某个端口是否被禁止????
- java script
- 使用JdbcTemplate报找不到这个类
- 怎么在jsp中设置一个数组全局变量,加static报错??能用application吗,怎么用
- SQLServer2000 JDBC驱动的安装
- 在jsp中如何实现翻页的功能??
- 请问在window 2000下如何设置Tomcat的运行内存量
- JExcelAPI导入Excel文件的数据到Mysql,中文字符乱码,请问要怎么处理?
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=myweb";
String user="sa";
String password="sa";
Connection conn= DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from [user]";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()) {
System.err.println(rs.getString(1));
System.err.println(rs.getString(2));
}
System.err.println("success");
}catch(Exception ex){
ex.printStackTrace();
}
import java.sql.*;
class JDBCTest2
{
public static void main(String[] args)
{
String driver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String url = "jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=pubs";
String user = "sa";
String pwd = "2306";
try
{
Class.forName(driver/*"com.microsoft.jdbc.sqlserver.SQLServerDriver"*/);
Connection conn =DriverManager.getConnection(url,user,pwd/*"jdbc:microsoft:sqlserver://127.0.0.1:1433;User=xjl;Password=2306;DatabaseName=Shop"*/);
System.out.println("数据库连接中....");
Statement stmt =conn.createStatement();
ResultSet results =stmt.executeQuery("select * from titles");
//int num=1;
while (results.next())
{
String titles =results.getString("title");
String prices =results.getString("price");
System.out.println("书名:"+titles+" 价格:"+prices);
}
stmt.close();
conn.close();
System.out.println("连接关闭中...");
}
catch (Exception e)
{
e.printStackTrace();
}
}
}
这个要安装JDBC-SQL驱动...驱动就自己上网就了...
安装后再将三个JAR文件放到JAVA安装目录...如:C:\jdk1.5.0\jre\lib\ext
三个JAR文件为:msbase.jar mssqlserver.jar msutil.jar