?? operatemysql.java
字號:
package org.database;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class OperateMySql implements OperateDataBase {
public void delete() {
// TODO Auto-generated method stub
System.setProperty("jdbc.drivers", "com.mysql.jdbc.Driver");
String url = "jdbc:mysql://localhost:3306/abc";
try {
Connection conn = DriverManager.getConnection(url, "root", "sa");
if (!conn.isClosed())
System.out.println("數(shù)據(jù)庫連接成功");
Statement stmt = conn.createStatement();
stmt.executeUpdate("delect from customer where name='name2'");
stmt.close();
conn.close();
} catch (SQLException e) {
e.getStackTrace();
}
}
public void insert() {
// TODO Auto-generated method stub
System.setProperty("jdbc.drivers", "com.mysql.jdbc.Driver");
String url = "jdbc:mysql://localhost:3306/abc";
try {
Connection conn = DriverManager.getConnection(url, "root", "sa");
if (!conn.isClosed())
System.out.println("數(shù)據(jù)庫連接成功");
Statement stmt = conn.createStatement();
stmt.executeUpdate(" insert into customer (name,password) values ('xiaowang','iloveyou')");
stmt.close();
conn.close();
} catch (SQLException e) {
e.getStackTrace();
}
}
public void query() {
// TODO Auto-generated method stub
System.setProperty("jdbc.drivers", "com.mysql.jdbc.Driver");
String url = "jdbc:mysql://localhost:3306/abc";
try {
Connection conn = DriverManager.getConnection(url, "root", "sa");
if (!conn.isClosed())
System.out.println("數(shù)據(jù)庫連接成功");
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("Select * from customer");
while (rs.next()) {
System.out.println("name:" + rs.getString(1) + "\tpassword:"
+ rs.getString(2));
}
rs.close();
stmt.close();
conn.close();
} catch (SQLException e) {
e.getStackTrace();
}
}
public void update() {
// TODO Auto-generated method stub
System.setProperty("jdbc.drivers", "com.mysql.jdbc.Driver");
String url = "jdbc:mysql://localhost:3306/abc";
try {
Connection conn = DriverManager.getConnection(url, "root", "sa");
if (!conn.isClosed())
System.out.println("數(shù)據(jù)庫連接成功");
Statement stmt = conn.createStatement();
stmt.executeUpdate("Update customer set name='NO.1' where name='xiaowang'");
stmt.close();
conn.close();
} catch (SQLException e) {
e.getStackTrace();
}
}
}
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -