如果你是刚学习,转贴这片文章给你了,给我加分喽!!1
----------------------------------------
**已安装了microsoft 驱动程序jdk1.4; win2000 server; MS sql2000;*/import java.sql.*;
class sql
{
public static void main(String[] agrs)
{
Connection cn=null;
Statement stmt=null;
String sql=null; try
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
}
catch(ClassNotFoundException ex)
{
System.out.println("Not find the Driver!");
}try
{
String urls="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=webroot";//webroot 库名.TALBE 是表名;
String user="sa";
String password="password";
cn= DriverManager.getConnection(urls,user,password);//stmt=cn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
stmt=cn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);sql="select top 10 * from TABLE1";
ResultSet rs= stmt.executeQuery(sql);
while(rs.next())
{
System.out.println(rs.getString(2)+" "+rs.getString(3)); } rs.first();
System.out.print(rs.getRow()+" ");
System.out.println(rs.getString(2)+" 1 "+rs.getString(3)); rs.last();
System.out.print(rs.getRow()+" ");
System.out.println(rs.getString(2)+" 2 "+rs.getString(3)); rs.previous();
System.out.print(rs.getRow()+" ");
System.out.println(rs.getString(2)+" 3 "+rs.getString(3)); rs.next();
System.out.print(rs.getRow()+" ");
System.out.println(rs.getString(2)+" 4 "+rs.getString(3)); rs.absolute(2);
System.out.print(rs.getRow()+" ");
System.out.println(rs.getString(2)+" 5 "+rs.getString(3));
/*
rs.afterLast();
System.out.print(rs.getRow()+" ");
System.out.println(rs.getString(2)+" "+rs.getString(3));
System.out.print(rs.isAfterLast()); rs.beforeFirst();
System.out.print(rs.getRow()+" ");
System.out.println(rs.getString(2)+" "+rs.getString(3));
*/ String sql1="update TABLE1 set 题目=? where id=? ";
PreparedStatement stmt1 = cn.prepareStatement(sql1);
String stat = new String("盛夏话足部保健");
String stat1 = UnicodeToGB(stat);//解决中文问题
stmt1.setString(1,stat1);
stmt1.setInt(2,3423);
stmt1.executeUpdate();
cn.commit(); //System.out.println(stat1);
//System.exit(0); //cn.setAutoCommit(false);
stmt.addBatch("update TABLE1 set 题目='盛夏话足部保健1' where id='3407'");
stmt.addBatch("update TABLE1 set 题目='夏季预防中暑膳食1' where id='3408'");
stmt.addBatch("INSERT INTO TABLE1 VALUES('11','12','13','','')");
stmt.addBatch("INSERT INTO TABLE1 VALUES('12','12','13','','')");
stmt.addBatch("INSERT INTO TABLE1 VALUES('13','12','13','','')");
stmt.addBatch("INSERT INTO TABLE1 VALUES('14','12','13','','')");
stmt.addBatch("INSERT INTO TABLE1 VALUES('15','12','13','','')");
stmt.addBatch("INSERT INTO TABLE1 VALUES('16','12','13','','')");
stmt.addBatch("INSERT INTO TABLE1 VALUES('17','12','13','','')");
stmt.addBatch("INSERT INTO TABLE1 VALUES('18','12','13','','')");
int [] updateCounts=stmt.executeBatch();
cn.commit();
stmt.close();
cn.close();
}
catch(SQLException e)
{
System.out.println("The SQLException error!");
}}
/*
*/public static String UnicodeToGB(String strIn){
byte[] b;
String strOut = null;
if(strIn == null || (strIn.trim()).equals(""))
return strIn;
try{
b = strIn.getBytes("GBK");
strOut = new String(b,"ISO8859_1");
}
catch(Exception e){
System.out.println("unicodeToGB exception : " + e.getMessage() + "\n");
}
return strOut;
}
/*
*/
}
----------------------------------------
**已安装了microsoft 驱动程序jdk1.4; win2000 server; MS sql2000;*/import java.sql.*;
class sql
{
public static void main(String[] agrs)
{
Connection cn=null;
Statement stmt=null;
String sql=null; try
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
}
catch(ClassNotFoundException ex)
{
System.out.println("Not find the Driver!");
}try
{
String urls="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=webroot";//webroot 库名.TALBE 是表名;
String user="sa";
String password="password";
cn= DriverManager.getConnection(urls,user,password);//stmt=cn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
stmt=cn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);sql="select top 10 * from TABLE1";
ResultSet rs= stmt.executeQuery(sql);
while(rs.next())
{
System.out.println(rs.getString(2)+" "+rs.getString(3)); } rs.first();
System.out.print(rs.getRow()+" ");
System.out.println(rs.getString(2)+" 1 "+rs.getString(3)); rs.last();
System.out.print(rs.getRow()+" ");
System.out.println(rs.getString(2)+" 2 "+rs.getString(3)); rs.previous();
System.out.print(rs.getRow()+" ");
System.out.println(rs.getString(2)+" 3 "+rs.getString(3)); rs.next();
System.out.print(rs.getRow()+" ");
System.out.println(rs.getString(2)+" 4 "+rs.getString(3)); rs.absolute(2);
System.out.print(rs.getRow()+" ");
System.out.println(rs.getString(2)+" 5 "+rs.getString(3));
/*
rs.afterLast();
System.out.print(rs.getRow()+" ");
System.out.println(rs.getString(2)+" "+rs.getString(3));
System.out.print(rs.isAfterLast()); rs.beforeFirst();
System.out.print(rs.getRow()+" ");
System.out.println(rs.getString(2)+" "+rs.getString(3));
*/ String sql1="update TABLE1 set 题目=? where id=? ";
PreparedStatement stmt1 = cn.prepareStatement(sql1);
String stat = new String("盛夏话足部保健");
String stat1 = UnicodeToGB(stat);//解决中文问题
stmt1.setString(1,stat1);
stmt1.setInt(2,3423);
stmt1.executeUpdate();
cn.commit(); //System.out.println(stat1);
//System.exit(0); //cn.setAutoCommit(false);
stmt.addBatch("update TABLE1 set 题目='盛夏话足部保健1' where id='3407'");
stmt.addBatch("update TABLE1 set 题目='夏季预防中暑膳食1' where id='3408'");
stmt.addBatch("INSERT INTO TABLE1 VALUES('11','12','13','','')");
stmt.addBatch("INSERT INTO TABLE1 VALUES('12','12','13','','')");
stmt.addBatch("INSERT INTO TABLE1 VALUES('13','12','13','','')");
stmt.addBatch("INSERT INTO TABLE1 VALUES('14','12','13','','')");
stmt.addBatch("INSERT INTO TABLE1 VALUES('15','12','13','','')");
stmt.addBatch("INSERT INTO TABLE1 VALUES('16','12','13','','')");
stmt.addBatch("INSERT INTO TABLE1 VALUES('17','12','13','','')");
stmt.addBatch("INSERT INTO TABLE1 VALUES('18','12','13','','')");
int [] updateCounts=stmt.executeBatch();
cn.commit();
stmt.close();
cn.close();
}
catch(SQLException e)
{
System.out.println("The SQLException error!");
}}
/*
*/public static String UnicodeToGB(String strIn){
byte[] b;
String strOut = null;
if(strIn == null || (strIn.trim()).equals(""))
return strIn;
try{
b = strIn.getBytes("GBK");
strOut = new String(b,"ISO8859_1");
}
catch(Exception e){
System.out.println("unicodeToGB exception : " + e.getMessage() + "\n");
}
return strOut;
}
/*
*/
}
解决方案 »
- 图像操作时:sun.awt.image.ToolkitImage cannot be cast to java.awt.image.BufferedImage
- jmf 无法安装啊
- 然后清空一个数组对象 如:Player player[]...
- this的用法和含义```
- 电影管理系统中的问题??急!!
- 请高手给我指点一下下面代码生成对象的个数
- 如何将一个字符串转换成数值型数据?注(是将String转numeric,不是转Float,Double,Integer)
- 高分请教关于发布applet的问题,解决就给分
- 搞不清JAVA的IO,在替换这样的方本,如何实现?在线
- 请推荐一个写java程序的编译环境……
- java 连接数据库的几个问题?
- "部署"的英文原文是什么?
据说微软提供的jdbc驱动不支持"反复查询",所以用net.sourceforge.jtds.jdbc.Driver(http://jtds.sourceforge.net/)
在Win2003Server上安装SQLSERVER2000,必须安装补丁sp3写类时注意:JAVA中CLASS.FORNAME方法必须是一个可以捕获的错误,把它放在TRY{}CATCH(CLASSNOTFOUNTEXCEPTION){}中就不会出错了
另CLASS_PATH中必须加入jtds-x-x-x.jar的完整路径名如:.\;...;D:\j2sdk1.4.2_01\jre\lib\ext\jtds-0.5.1.jar;/*
* Author:liufei
* Homepage: www.liufei.com
* Copyright 2003 henan SUNCER software Inc. All rights reserved.
*/
import java.sql.*;
import java.util.*;
class Sql {
public static void main(String[] args) {
try{
String query="select * from Orders";
String URL="jdbc:jtds:sqlserver://135.0.0.2:1433/Northwind;USER=sa;PASSWORD=webserver";
Class.forName("net.sourceforge.jtds.jdbc.Driver");
Connection conn=DriverManager.getConnection(URL);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
ResultSet rs=stmt.executeQuery(query);
int i=1;
for(i=1;i<10;i++){
rs.next();
System.out.println(rs.getString(1));
}
}catch(Exception e){
System.out.println(e.getMessage());
}
}
}
用JSP连接:必须将jtds.jar放至WEB-INF/lib目录下test.jsp内容如下:<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<html>
<body>
<%Class.forName("net.sourceforge.jtds.jdbc.Driver").newInstance();
String url="jdbc:jtds:sqlserver://135.0.0.2:1433/Northwind;USER=sa;PASSWORD=webserver"; Connection conn= DriverManager.getConnection(url);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from Orders";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()) {%>
您的第一个字段内容为:<%=rs.getString(1)%>
您的第二个字段内容为:<%=rs.getString(2)%>
<%}%>
<%out.print("数据库操作成功,恭喜你");%>
<%rs.close();
stmt.close();
conn.close();
%>
</body>
</html>
现在有一个问题:
我用Azraelfan提供的代码,编译没有问题,但ms 的jdbc驱动怎么安装?我下载的只有三个jar文件.请告诉我怎么安装这三个jar文件,放到那个目录下?又如何发布呢?谢谢大家!!
有没有冲突?
每次运行*.class文件时必须先运行set classpath=命令吗?
谢谢!