package test;import java.sql.*;public class Test {
public static void main(String[] args) { try{
Statement sta;
String use="sy";
String password="123";
String driver="com.mysql.jdbc.Driver";
String serch="select * from t_table"; Class.forName(driver);
String ds="jdbc:mysql://192.168.0.1/card_manager";
Connection con=DriverManager.getConnection(ds,use,password); ResultSet query=null;
sta=con.createStatement();
query=sta.executeQuery(serch); while(query.next())
System.out.println(query.getString(1)+" "+query.getString(2)
+" "+query.getString(3)+" "+query.getString(4)
+" "+query.getString(5)+" "+query.getString(6)
+" "+query.getString(7)+" "+query.getString(8)
+" "+query.getString(9)+" "+query.getString(10)
);
query.close();
}
catch(ClassNotFoundException ex){
System.err.println(ex);
}
catch(SQLException en){
System.err.println(en);
}
}
}
public static void main(String[] args) { try{
Statement sta;
String use="sy";
String password="123";
String driver="com.mysql.jdbc.Driver";
String serch="select * from t_table"; Class.forName(driver);
String ds="jdbc:mysql://192.168.0.1/card_manager";
Connection con=DriverManager.getConnection(ds,use,password); ResultSet query=null;
sta=con.createStatement();
query=sta.executeQuery(serch); while(query.next())
System.out.println(query.getString(1)+" "+query.getString(2)
+" "+query.getString(3)+" "+query.getString(4)
+" "+query.getString(5)+" "+query.getString(6)
+" "+query.getString(7)+" "+query.getString(8)
+" "+query.getString(9)+" "+query.getString(10)
);
query.close();
}
catch(ClassNotFoundException ex){
System.err.println(ex);
}
catch(SQLException en){
System.err.println(en);
}
}
}
不过query.close();应该写在while语句的外面。
while(query.next()){
System.out.println(query.getString(1)+" "+query.getString(2)
+" "+query.getString(3)+" "+query.getString(4)
+" "+query.getString(5)+" "+query.getString(6)
+" "+query.getString(7)+" "+query.getString(8)
+" "+query.getString(9)+" "+query.getString(10)
); }
query.close();
你要是要特殊的操作可以在while语句内部实现。这个是取数的(select)
要是删除(delete)
String serch="delete from t_table";
....
sta.executeUpdate(serch);
要是插入(insert)
String serch="insert into t_table(...) values(...)";//你的insert语句
....
sta.executeUpdate(serch);
String ds="jdbc:mysql://192.168.0.1/card_manager";
和
String sDBDriver="sun.jdbc.odbc.JdbcOdbcDriver";
String sConnStr="jdbc:odbc:teachers";
有什么不同?
String ds="jdbc:mysql://192.168.0.1/card_manager";
用JDBC来连mysql
String sDBDriver="sun.jdbc.odbc.JdbcOdbcDriver";
String sConnStr="jdbc:odbc:teachers";
JDBC用一个ODBC来做桥接来连接一个数据库
//192.168.0.1/card_manager是数据库所在的机器及目录?