import java.sql.*;
public class InsertCoffees { public static void main(String args[]) {
/****************
DataTable dt = new JDBCAdapter(
"jdbc:sybase://dbtest:1455/spring",
"SELECT * FROM test",
"connect.sybase.SybaseDriver",
"guest",
"trustworthy");
*******************************/ String url = "jdbc:sybase://dbtest:1455/spring";
Connection con;
Statement stmt;
String query = "select COF_NAME, PRICE from COFFEES";
try {
Class.forName("connect.sybase.SybaseDriver");
} catch(java.lang.ClassNotFoundException e) {
System.err.print("ClassNotFoundException: ");
System.err.println(e.getMessage());
} try { con = DriverManager.getConnection(url,
"guest", "trustworthy");
stmt = con.createStatement();
stmt.executeUpdate("insert into COFFEES " +
"values('Colombian', 00101, 7.99, 0, 0)");
stmt.executeUpdate("insert into COFFEES " +
"values('French_Roast', 00049, 8.99, 0, 0)");
stmt.executeUpdate("insert into COFFEES " +
"values('Espresso', 00150, 9.99, 0, 0)");
stmt.executeUpdate("insert into COFFEES " +
"values('Colombian_Decaf', 00101, 8.99, 0, 0)");
stmt.executeUpdate("insert into COFFEES " +
"values('French_Roast_Decaf', 00049, 9.99, 0, 0)");
ResultSet rs = stmt.executeQuery(query);
System.out.println("Coffee Break Coffees and Prices:");
while (rs.next()) {
String s = rs.getString("COF_NAME");
float f = rs.getFloat("PRICE");
System.out.println(s + " " + f);
}
stmt.close();
con.close();
} catch(SQLException ex) {
System.err.println("SQLException: " + ex.getMessage());
}
}
}
public class InsertCoffees { public static void main(String args[]) {
/****************
DataTable dt = new JDBCAdapter(
"jdbc:sybase://dbtest:1455/spring",
"SELECT * FROM test",
"connect.sybase.SybaseDriver",
"guest",
"trustworthy");
*******************************/ String url = "jdbc:sybase://dbtest:1455/spring";
Connection con;
Statement stmt;
String query = "select COF_NAME, PRICE from COFFEES";
try {
Class.forName("connect.sybase.SybaseDriver");
} catch(java.lang.ClassNotFoundException e) {
System.err.print("ClassNotFoundException: ");
System.err.println(e.getMessage());
} try { con = DriverManager.getConnection(url,
"guest", "trustworthy");
stmt = con.createStatement();
stmt.executeUpdate("insert into COFFEES " +
"values('Colombian', 00101, 7.99, 0, 0)");
stmt.executeUpdate("insert into COFFEES " +
"values('French_Roast', 00049, 8.99, 0, 0)");
stmt.executeUpdate("insert into COFFEES " +
"values('Espresso', 00150, 9.99, 0, 0)");
stmt.executeUpdate("insert into COFFEES " +
"values('Colombian_Decaf', 00101, 8.99, 0, 0)");
stmt.executeUpdate("insert into COFFEES " +
"values('French_Roast_Decaf', 00049, 9.99, 0, 0)");
ResultSet rs = stmt.executeQuery(query);
System.out.println("Coffee Break Coffees and Prices:");
while (rs.next()) {
String s = rs.getString("COF_NAME");
float f = rs.getFloat("PRICE");
System.out.println(s + " " + f);
}
stmt.close();
con.close();
} catch(SQLException ex) {
System.err.println("SQLException: " + ex.getMessage());
}
}
}
解决方案 »
- 请教牛人,通过java怎么截取网络数据包????急急!!!!
- 一个很基本的问题,下载了plugin如何安装呢?在那里安装呢
- jxl如何向合并单元格写入值?
- 问一个显示9*9的乘法口诀表的代码
- 关于private 的构造函数?求答案,解决马上揭帖!
- 高分求教jsdk中的NoSuchMethodError原委!
- 一个菜鸟的问题:Exception in thread "main" java.lang.NoClassDefFoundError: HelloWorld
- 【请高手作答:《】import、package和classpath!!!
- 请问怎样远程监控WEB SERVER是否运行?
- 新人求解Java面向对象,Java牛的速进!
- 送分的问题..
- classpath & package
请高手指点,谢谢
也可以把大家搜索到的结果告诉我
我的信箱:[email protected]