S2_第七章JDBC

CURD：增删改查

Class.forName(JDBC驱动类)

//1.导入jar包，部署

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;




public class AddTest {
	//1.导入jar包，部署
	//2.加载驱动（包）只加载一次
	static{
		try {
			Class.forName("com.mysql.jdbc.Driver");
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		}
	}
	public static void main(String[] args) {
		String url = "jdbc:mysql://localhost:3306/bdqn229";
		String user = "root";//账户名
		String pwd = "root";//密码
		Statement st =null;
		Connection conn = null;
		try {
			//3.创建连接对象
			conn = (Connection) DriverManager.getConnection(url, user, pwd);
			//4.Sql语句
			String sql = "insert into bank  ";
			//5.执行对象
			st = conn.createStatement();
			//6.执行
			int result = st.executeUpdate(sql);
			//7.返回结果
			if(result>0){
				System.out.println("修改成功");
			}else{
				System.out.println("修改失败");
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}finally{
			try {
				if(st!=null){
					st.close();
				}
				if(conn!=null){
					conn.close();
				}
			} catch (Exception e2) {
				// TODO: handle exception
			}
		}
	}
}

prepareStatement:

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class epetadmin {
	//1.导入jar包，部署
	//2.加载驱动（包）只加载一次
	static{
		try {
			Class.forName("com.mysql.jdbc.Driver");
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		}
	}
	public static void main(String[] args) {
		String url = "jdbc:mysql://localhost:3306/epet";
		String user = "root";//账户名
		String pwd = "root";//密码
		
		Connection conn = null;
		PreparedStatement ps = null;
		ResultSet rs = null;
		//3.创建连接对象
		try {
			conn = DriverManager.getConnection(url, user, pwd);
			//4.Sql语句
			String sql = "insert into Dog(id,name,zhong) values(?,?,?) ";
			//5.执行对象
			ps = conn.prepareStatement(sql);
			//6.执行
			ps.setInt(1,1 );
			ps.setString(2, "阿斯顿");
			ps.setString(3, "sdaad");
			ps.execute();
			
		} catch (SQLException e) {
			e.printStackTrace();
		}finally{
			try {
				if(conn!=null){
					conn.close();
				}
				if(ps!= null){
					ps.close();
				}
			} catch (Exception e2) {
			}
		}
	}
}