Java????mySql???JDBC?????????
???????????? ???????[ 2014/4/24 10:42:26 ] ????????mySql ?????
????????JDBC?????????
????????????????:
???????????????JDBC????????????????????????в?????????????????????????????????????????????
?????????
????String driver = "com.mysql.jdbc.Driver";
????Class.forName(driver);//????mysql???????Class.forName("????????")???м???
????????????????????????????????????????????????????????????????в???
???????:
????String url = "jdbc:mysql://localhost:3306/???????";//???????????????
????Connection conn = null;//????????????????
????conn = DriverManager.getConnection(url??"root"??"root");//?????????
???????????????????????????????(?ò????????????)
????PreparedStatement pstmt = null; //4.????????????????
????String sql = null;//???????????
????sql = "INSERT INTO ???? (??????????????) VALUES (???????)" ;//???????????????????????
????pstmt = conn.prepareStatement(sql);
????pstmt.setString(1???) ;
????pstmt.setString(2???) ;
????pstmt.setString(3???) ;
????pstmt.executeUpdate() ;
?????????????????????????????????????????????????
???????:
????ResultSet rs = null;
????sql = "select ?????????????? from ????";
????pstmt = conn.prepareStatement(sql);
????rs = pstmt.executeQuery();
????rs.getString("????");???巽???????????????????????
???????崠???????????????и??????????????????????????????????????????
???????:
????rs.close();//?????????в????????????д???????
????ptsmt.close();
????conn.close();
???????????JDBC????????????????????????????????????????????.
??????
???·???
??????????????????
2023/3/23 14:23:39???д?ò??????????
2023/3/22 16:17:39????????????????????Щ??
2022/6/14 16:14:27??????????????????????????
2021/10/18 15:37:44???????????????
2021/9/17 15:19:29???·???????·
2021/9/14 15:42:25?????????????
2021/5/28 17:25:47??????APP??????????
2021/5/8 17:01:11