import java.sql.*;
public class DataBasePractice {
public static void main(String[] args) {
//声æConnection对象
Connection con;
//驱å¨ç¨åºå
String driver = "com.mysql.jdbc.Driver";
//URLæåè¦è®¿é®çæ°æ®åºåmydata
String url = "jdbc:mysql://localhost:3306/mydata";
//MySQLé
ç½®æ¶çç¨æ·å
String user = "root";
//MySQLé
ç½®æ¶çå¯ç
String password = "root";
//éåæ¥è¯¢ç»æé
try {
//å 载驱å¨ç¨åº
Class.forName(driver);
//1.getConnection()æ¹æ³ï¼è¿æ¥MySQLæ°æ®åºï¼ï¼
con = DriverManager.getConnection(url,user,password);
if(!con.isClosed())
System.out.println("Succeeded connecting to the Database!");
//2.å建statement类对象ï¼ç¨æ¥æ§è¡SQLè¯å¥ï¼ï¼
Statement statement = con.createStatement();
//è¦æ§è¡çSQLè¯å¥
String sql = "select * from student";
//3.ResultSetç±»ï¼ç¨æ¥åæ¾è·åçç»æéï¼ï¼
ResultSet rs = statement.executeQuery(sql);
System.out.println("-----------------");
System.out.println("æ§è¡ç»æå¦ä¸æ示:");
System.out.println("-----------------");
System.out.println(" å¦å·" + "\t" + " å§å");
System.out.println("-----------------");
String name = null;
String id = null;
while(rs.next()){
//è·åstunameè¿åæ°æ®
name = rs.getString("stuname");
//è·åstuidè¿åæ°æ®
id = rs.getString("stuid");
//é¦å
使ç¨ISO-8859-1å符éå°name解ç 为åèåºå并å°ç»æåå¨æ°çåèæ°ç»ä¸ã
//ç¶å使ç¨GB2312å符é解ç æå®çåèæ°ç»ã
name = new String(name.getBytes("ISO-8859-1"),"gb2312");
//è¾åºç»æ
System.out.println(id + "\t" + name);
}
rs.close();
con.close();
} catch(ClassNotFoundException e) {
//æ°æ®åºé©±å¨ç±»å¼å¸¸å¤ç
System.out.println("Sorry,can`t find the Driver!");
e.printStackTrace();
} catch(SQLException e) {
//æ°æ®åºè¿æ¥å¤±è´¥å¼å¸¸å¤ç
e.printStackTrace();
}catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
}finally{
System.out.println("æ°æ®åºæ°æ®æåè·åï¼ï¼");
}
}
}
å¨ä¸é¢while代ç 段åé¢æ·»å 以ä¸ä»£ç 段ï¼
String name = null;
String id = null;
while(rs.next()){
//è·åstunameè¿åæ°æ®
name = rs.getString("stuname");
//è·åstuidè¿åæ°æ®
id = rs.getString("stuid");
//é¦å
使ç¨ISO-8859-1å符éå°name解ç 为åèåºå并å°ç»æåå¨æ°çåèæ°ç»ä¸ã
//ç¶å使ç¨GB2312å符é解ç æå®çåèæ°ç»ã
name = new String(name.getBytes("ISO-8859-1"),"gb2312");
//è¾åºç»æ
System.out.println(id + "\t" + name);
}
PreparedStatement psql;
ResultSet res;
//é¢å¤çæ·»å æ°æ®ï¼å
¶ä¸æ两个åæ°--âï¼â
psql = con.prepareStatement("insert into student values(?,?)");
psql.setInt(1, 8); //设置åæ°1ï¼å建id为5çæ°æ®
psql.setString(2, "xiaogang"); //设置åæ°2ï¼name 为å°æ
psql.executeUpdate(); //æ§è¡æ´æ°
//é¢å¤çæ´æ°ï¼ä¿®æ¹ï¼æ°æ®
psql = con.prepareStatement("update student set stuname = ? where stuid = ?");
psql.setString(1,"xiaowang"); //设置åæ°1ï¼å°nameæ¹ä¸ºçäº
psql.setInt(2,10); //设置åæ°2ï¼å°id为2çæ°æ®åä¿®æ¹
psql.executeUpdate();
//é¢å¤çå é¤æ°æ®
psql = con.prepareStatement("delete from student where stuid = ?");
psql.setInt(1, 5);
psql.executeUpdate();
//æ¥è¯¢ä¿®æ¹æ°æ®åstudent表ä¸çæ°æ®
psql = con.prepareStatement("select*from student");
res = psql.executeQuery(); //æ§è¡é¢å¤çsqlè¯å¥
System.out.println("æ§è¡å¢å ãä¿®æ¹ãå é¤åçæ°æ®");
while(res.next()){
name = res.getString("stuname");
id = res.getString("stuid");
name = new String(name.getBytes("ISO-8859-1"),"gb2312");
System.out.println(id + "\t" + name);
}
res.close();
psql.close();
温馨提示:答案为网友推荐,仅供参考