具体操纵步骤可分为一下几步:
1.创建数据库
在数据库work中创建表users,字段username,password.
2.在MyEclipse中新建一个java project项目,并取名为jdbcexample
3.添加连接MySQL所需要的连接类包(mysql-connector-java-5.1.6-bin.jar) ->这个包为重中之重,切不可遗漏。
4.在项目中创建实现类:
添加数据的类JDBCExample01.java
Code
package com.example;
import java.sql.*;
import com.mysql.jdbc.PreparedStatement;
public class JDBCExample {
public static void main(String[] args) {
String driver = "com.mysql.jdbc.Driver";
String url = "jdbc:mysql://localhost:3306/work";
String username = "root";
String password = "";
String sql = "insert into users(username,password) values(?,?)";
try {
Class.forName(driver);
Connection conn = DriverManager.getConnection(url, username,
password);
//Statement stat=conn.createStatement();
PreparedStatement pstmt = (PreparedStatement) conn
.prepareStatement(sql);
pstmt.setString(1, "xiaoxiao");
pstmt.setString(2, "thinking in java");
pstmt.executeUpdate();
pstmt.close();
conn.close();
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
查询数据的类JDBCExample02.java
Code
package com.example;
import java.sql.*;
import com.mysql.jdbc.PreparedStatement;
public class JDBCExample02 {
public static void main(String[] args) {
String driver = "com.mysql.jdbc.Driver";
String url = "jdbc:mysql://localhost:3306/work";
String username = "root";
String password = "";
String sql = "select * from users";
try {
Class.forName(driver);
Connection conn = DriverManager.getConnection(url, username,
password);
//Statement stat=conn.createStatement();
PreparedStatement pstmt = (PreparedStatement) conn.prepareStatement(sql);
ResultSet rs = pstmt.executeQuery(); //调用方法,得到一个ResultSet的对象,通过while循环输出
while(rs.next()){
System.out.println("name:"+rs.getString("username")+"\tpassword:"+rs.getString("password"));
}
rs.close();
pstmt.close();
conn.close();
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
5.执行操纵
如果改成用oracle实现,则再添加类中的代码可换成
Code
public static void main(String[] args){
String driver="oracle.jdbc.driver.Oracle";
String url="jdbc:oracle:thin:@****;1521:ora9";(**为所要连接的数据库的IP地址)
String username="";
String password="";
String sql="insert into users(username,password) values(?,?)";
}
其他地方都可保持不变,可见在数据库连接中,唯一的不同点无非就是Driver的使用,其他都大同小异。