import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;import javax.swing.JOptionPane;
import javax.swing.JPopupMenu;import com.mysql.jdbc.Statement;public class T1 {
public static void main(String[] args) { try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection cot = DriverManager.getConnection(
"jdbc:mysql://localhost:3306/student? characterEncoding=gbk",
"root", "123");
Statement stm = (Statement) cot.createStatement();// 提交查巡
String sql = "select * from student; ";
ResultSet rs = stm.executeQuery(sql);// 取得查巡結果 while (rs.next()) {
System.out.println(rs.getString(3));
}
if (rs.next())
JOptionPane.showMessageDialog(null, "11111");
else { sql = "insert into student(snumber,sname,ssex,sclass,scollect,chinese) values (663355,66737,95,79,70,90)";
int n = stm.executeUpdate(sql); // 增加数据
if (n > 0) {
JOptionPane.showMessageDialog(null, "成功");
} else {
JOptionPane.showMessageDialog(null, "失败");
} } } catch (Exception ee) {
ee.printStackTrace();
} }}
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;import javax.swing.JOptionPane;
import javax.swing.JPopupMenu;import com.mysql.jdbc.Statement;public class T1 {
public static void main(String[] args) { try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection cot = DriverManager.getConnection(
"jdbc:mysql://localhost:3306/student? characterEncoding=gbk",
"root", "123");
Statement stm = (Statement) cot.createStatement();// 提交查巡
String sql = "select * from student; ";
ResultSet rs = stm.executeQuery(sql);// 取得查巡結果 while (rs.next()) {
System.out.println(rs.getString(3));
}
if (rs.next())
JOptionPane.showMessageDialog(null, "11111");
else { sql = "insert into student(snumber,sname,ssex,sclass,scollect,chinese) values (663355,66737,95,79,70,90)";
int n = stm.executeUpdate(sql); // 增加数据
if (n > 0) {
JOptionPane.showMessageDialog(null, "成功");
} else {
JOptionPane.showMessageDialog(null, "失败");
} } } catch (Exception ee) {
ee.printStackTrace();
} }}
不过我怎么看到有2个rs.next()呢??
是写错这里还是需要这样呢??
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;import javax.swing.JOptionPane;
import javax.swing.JPopupMenu;import com.mysql.jdbc.Statement;public class T1 {
public static void main(String[] args) {try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection cot = DriverManager.getConnection(
"jdbc:mysql://localhost:3306/student? characterEncoding=gbk",
"root", "123");
Statement stm = (Statement) cot.createStatement();// 提交查巡
String sql = "select * from student; ";
ResultSet rs = stm.executeQuery(sql);// 取得查巡結果
boolean hasResult = false;while (rs.next()) {
System.out.println(rs.getString(3));
hasResult = true;
}
if (hasResult)
JOptionPane.showMessageDialog(null, "11111");
else {sql = "insert into student(snumber,sname,ssex,sclass,scollect,chinese) values (663355,66737,95,79,70,90)";
int n = stm.executeUpdate(sql); // 增加数据
if (n > 0) {
JOptionPane.showMessageDialog(null, "成功");
} else {
JOptionPane.showMessageDialog(null, "失败");
}}} catch (Exception ee) {
ee.printStackTrace();
}}}
这个意思?
.....................
}
if (rs.next()){
.....................
}
是想问这个吗?
package odbcOrJdbc;import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;public class MySqlConnection { public static void main(String[] args) throws Exception {
String url="jdbc:mysql://localhost:3306/test";
Class.forName("org.gjt.mm.mysql.Driver");
// "jdbc:mysql://[hostname][:port]/dbname[?param1=value1][¶m2=value2]"
String username="root";
String password="admin";// Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection connection = DriverManager.getConnection(url,username,password);
// Connection connection = DriverManager.getConnection(url);
// System.out.println(connection);
// com.pointbase.jdbc.jdbcUniversalDriver
// jdbc:pointbase:server://localhost:9092/sample
Statement statement = connection.createStatement();
// String sql ="select * from jiangwh_tbl";
// Statement statement = connection.createStatement();
//
//// statement.execute(sql);
// ResultSet resultSet = statement.executeQuery(sql);
// while(resultSet.next()){
// System.out.println(resultSet.getString(1));
// System.out.println(resultSet.getString(2));
// System.out.println(resultSet.getInt(3));
// }
connection.setAutoCommit(false);
for(int i=200;i<12000;i++){
String sql = "insert into jiangwh_tbl values('briup" +i+"','briup"+i+"'," +i+")";
statement.addBatch(sql);
}
statement.executeBatch();
connection.commit();
}
}
自己去看看清楚API吧。ResultSet.net()这个方法。
应该是 next()吧