实例1如下：
//import com.microsoft.*; import java.sql.*; import java.net.URL; class insert {
public static void main(String[] args) {
String
url=\\
String query=\ String query1=\values(10,'Hanbao','Sweet')\
String query2=\values(11,'Naicha','Coffee taste')\ try {
Class.forName(\erDriver\
Connection
con=DriverManager.getConnection(url,\ Statement stmt=con.createStatement(); stmt.executeUpdate(query1); stmt.executeUpdate(query2);
stmt.close(); con.close();
}
catch(SQLException ex) {
}
catch(java.lang.Exception ex) {
ex.printStackTrace(); } } }
实例2如下：
//import com.microsoft.*; import java.sql.*; import java.net.URL; class java2sqlserver {
public static void main(String[] args) {
String
url=\5;DatabaseName=northwind\
String query=\ try {
Class.forName(\ServerDriver\
//DriverManager.setLogStream(System.out); Connection
con=DriverManager.getConnection(url);
checkForWarning(con.getWarnings()); Statement stmt=con.createStatement(); ResultSet rs=stmt.executeQuery(query); dispResultSet(rs); rs.close(); stmt.close(); con.close(); }
catch(SQLException ex) {
System.out.println(ex.toString()+\caught----\
while(ex!=null) {
System.out.print(\ate());
System.out.print(\e());
System.out.print(\de());
ex=ex.getNextException();
System.out.println(\ } }
catch(java.lang.Exception ex) {
ex.printStackTrace(); } }
private {
boolean rc=false; if(warn!=null) {
System.out.println(\ rc=true;
while(warn!=null) {
static boolean checkForWarning(SQLWarning warn) System.out.print(\State());
System.out.print(\age());
System.out.print(\Code());
System.out.println(\ warn=warn.getNextWarning();
} }
return rc; }
private static void dispResultSet(ResultSet rs) throws SQLException { int i;
ResultSetMetaData rsmd=rs.getMetaData(); int numCols=rsmd.getColumnCount(); for(i=1;i<=numCols;i++) {
if(i>1) System.out.print(\ System.out.print(rsmd.getColumnLabel(i));
}
System.out.println(\ boolean more=rs.next(); while(more) {
for(i=1;i if(i<1) System.out.print(\ System.out.println(rs.getString(i)); } System.out.println(\ more=rs.next(); } } //System.out.println(\ }