package com.hkd.test;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import com.mysql.jdbc.Statement;
public class test {
public static void main(String[] args) {
try {
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
System.out.println("创建失败");
e.printStackTrace();
}
try {
Connection conn =DriverManager.getConnection("jdbc:mysql://localhost:3306/school", "root", "root");
java.sql.Statement sta =conn.createStatement();
//int a =sta.executeUpdate("insert into school values(null,'大侠',16,null)");
//if(a>0){
//System.out.println("成功");
//}else{
// System.out.println("失败");
//}
String sql ="select * from school";
ResultSet rs = sta.executeQuery(sql);
while(rs.next()){
System.out.println(rs.getInt("studentno"));
System.out.println(rs.getString("name"));
System.out.println(rs.getInt("age"));
System.out.println(rs.getInt("tel"));
}
rs.close();
sta.close();
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import com.mysql.jdbc.Statement;
public class test {
public static void main(String[] args) {
try {
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
System.out.println("创建失败");
e.printStackTrace();
}
try {
Connection conn =DriverManager.getConnection("jdbc:mysql://localhost:3306/school", "root", "root");
java.sql.Statement sta =conn.createStatement();
//int a =sta.executeUpdate("insert into school values(null,'大侠',16,null)");
//if(a>0){
//System.out.println("成功");
//}else{
// System.out.println("失败");
//}
String sql ="select * from school";
ResultSet rs = sta.executeQuery(sql);
while(rs.next()){
System.out.println(rs.getInt("studentno"));
System.out.println(rs.getString("name"));
System.out.println(rs.getInt("age"));
System.out.println(rs.getInt("tel"));
}
rs.close();
sta.close();
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}