Java 实现连接sql server 2000（JDBC数据库访问例子）(2)

实例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(\ }

百度搜索“77cn”或“免费范文网”即可找到本站免费阅读全部范文。收藏本站方便下次阅读，免费范文网，提供经典小说综合文库Java 实现连接sql server 2000（JDBC数据库访问例子）(2)在线全文阅读。