jdbc实现数据库的增删改查

package cpm.ytu.jdbc;

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

import com.mysql.jdbc.Statement;
public class JDBCTest {//实现数据连接
	public static Connection getConnection() {
		Connection conn=null;
		try {
			Class.forName("com.mysql.jdbc.Driver");
			conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/jsp_db","root","1234");
		} catch (Exception e) {
			e.printStackTrace();
		}
		return conn;
	}
	public static void insert() {//数据表中插入数据
		Connection conn=getConnection();
		try {
			String sql="insert into tal_user(id,name,password,email)"
					+ "values(5,'pet','234','36@178.com')";
			Statement st= (Statement) conn.createStatement();
			int count =st.executeUpdate(sql);
			System.out.println("向用户表插入了"+count+"条记录");
		} catch (Exception e) {
			e.printStackTrace();
		}
	}