//注册驱动

//DriverManager.registerDriver(new Driver());此方法被淘汰

Class.forName("com.mysql.jdbc.Driver");

//建立连接2

	public static Connection  getConn2() throws SQLException

	{

		Properties info= new Properties();

		info.setProperty("user", "root");

		info.setProperty("password", "123");

		conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/day06",info);

		return conn;

	}

	//建立连接3

		public static Connection  getConn3() throws SQLException

		{

			Connection cnn=DriverManager.getConnection("jdbc:mysql://localhost:3306/day06？user=root&password=123");

			return conn;

		}

//获取链接

	conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/day06","root","247418");

//对数据库的操作--选择

	public static ResultSet QueryTest() throws Exception

	{

		rs=sta.executeQuery("select * from users");

		return rs;

	}

	//对数据库的操作--插入

	public static int insertTest() throws Exception

	{

		int num_i=sta.executeUpdate("insert into users values(005,'zhansan','123','zs@sina.com','1980-12-04')");

		return num_i;

	}

	//对数据库的操作--删除

	public static int deleteTest() throws Exception

	{

		int num_d=sta.executeUpdate("delete from users where id='001'");

		return num_d;

	}

	//对数据库的操作--更新

	public static int updateTest() throws Exception

	{

		int num_d=sta.executeUpdate("update users set name='ooo' where id='002'");

		return num_d;

	}

//对结果的操作1

		public static void QueryRes1() throws Exception

		{

			while(rs.next())

			{

				User u=new User();

				u.setId(rs.getInt("id"));

				u.setName(rs.getString("name"));

				u.setPassword(rs.getString("password"));

				u.setEmail(rs.getString("email"));

				u.setBirthday(rs.getDate("birthday"));

				al.add(u);

			}

		}

		//对结果的操作2

		public static void QueryRes2() throws Exception

		{

			while(rs.next())

			{

				System.out.println(rs.getObject(1));

				System.out.println(rs.getObject(2));

				System.out.println(rs.getObject(3));

				System.out.println(rs.getObject(4));

				System.out.println(rs.getObject(5));

				System.out.println("-----------------");

			}

		}

package songyan.jdbc.entity;

import java.util.Date;

public class User {

	private int id;

	private String name;

	private String password;

	private String email;

	private Date birthday;

	public int getId() {

		return id;

	}

	public void setId(int id) {

		this.id = id;

	}

	public String getName() {

		return name;

	}

	public void setName(String name) {

		this.name = name;

	}

	public String getPassword() {

		return password;

	}

	public void setPassword(String password) {

		this.password = password;

	}

	public String getEmail() {

		return email;

	}

	public void setEmail(String email) {

		this.email = email;

	}

	public Date getBirthday() {

		return birthday;

	}

	public void setBirthday(Date birthday) {

		this.birthday = birthday;

	}

}