JDBC的连接

来源：互联网发布：美国渔鹰飞机飞行数据编辑：程序博客网时间：2024/04/28 22:00
import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;public class MyConnection {static Statement statement = null;static PreparedStatement preStat = null;static ResultSet resultSet = null;static Connection con = null;public static void main(String[] args) {MyConnection mycon = new MyConnection();Connection con = mycon.getConnection();// ********************数据遍历// Statement用来执行sql语句try {statement = con.createStatement();// 要执行的SQL语句String sql = "select * from Student";// 结果集resultSet = statement.executeQuery(sql);// 遍历数据while (resultSet.next()) {String Sid = resultSet.getString(1);String Sname = resultSet.getString(2);String Sage = resultSet.getString(3);String Ssex = resultSet.getString(4);String Szhuanye = resultSet.getString(5);System.out.println("Sid:" + Sid + "  Sname:" + Sname+ "  Sage:" + Sage + "  Ssex:" + Ssex + "  Szhuanye:"+ Szhuanye);}} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}// ************执行增删改 字符串的拼接 *********// insert into student valuse('"+Sid+"','"+Sname+"'.......);// ****************预处理执行增删改**************String insert = "insert into student values(?,?,?,?,?)";String update = "update student set Sname=? where Sid=?";String delete = "delete from student where Sid=?";// 增加数据try {preStat = con.prepareStatement(insert);// 这里可能还要判断一下数据库的约束条件preStat.setString(1, "100080");preStat.setString(2, "我试试");preStat.setString(3, "100");preStat.setString(4, "男");preStat.setString(5, "100080");// 执行sql语句preStat.executeUpdate();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}// **********更新数据try {preStat = con.prepareStatement(update);preStat.setString(1, "更改");preStat.setString(2, "100080");preStat.executeUpdate();} catch (SQLException e1) {// TODO Auto-generated catch blocke1.printStackTrace();}// **********删除数据try {preStat = con.prepareStatement(delete);preStat.setString(1, "100080");preStat.executeUpdate();} catch (SQLException e1) {// TODO Auto-generated catch blocke1.printStackTrace();}// ************************预处理语句PreparedStatement 查询数据try {preStat = con.prepareStatement("select * from Student where Sid=?");// 设置参数 表示 第一个参数 为100002preStat.setString(1, "100080");// 执行预处理语句resultSet = preStat.executeQuery();// 遍历数据while (resultSet.next()) {String Sid = resultSet.getString(1);String Sname = resultSet.getString(2);String Sage = resultSet.getString(3);String Ssex = resultSet.getString(4);String Szhuanye = resultSet.getString(5);System.out.println("Sid:" + Sid + "  Sname:" + Sname+ "  Sage:" + Sage + "  Ssex:" + Ssex + "  Szhuanye:"+ Szhuanye);}} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}// 数据库连接方法public Connection getConnection() {// 驱动程序名String driver = "com.mysql.jdbc.Driver";// URL指向要访问的数据库名scoreString url = "jdbc:mysql://localhost:3306/score?useUnicode=true&characterEncoding=UTF-8";//注意score后面家的代码是指定编码   不知道 有可能乱码    // String url="jdbc:mysql://127.0.0.1:3306/score";// MySQL配置时的用户名String user = "root";// MySQL配置时的密码String password = "123456";try {// 加载驱动 通过名字把类的源数据对象加载到内存中Class.forName(driver);// 连续数据库con = DriverManager.getConnection(url, user, password);if (!con.isClosed())System.out.println("数据库连接成功！");} catch (Exception e) {e.printStackTrace();}return con;}}
1 0