Java JDBC连接mysql数据库详解

准备工作导入mysql驱动 的jar包mysql-connector-java-5.1.44-bin.jar

创建实体类

public class tbl_user {


	private String uname;
	private String upassword;
	public String getUname() {
		return uname;
	}
	public void setUname(String uname) {
		this.uname = uname;
	}
	public String getUpassword() {
		return upassword;
	}
	public void setUpassword(String upassword) {
		this.upassword = upassword;
	}
	@Override
	public String toString() {
		return "tbl_user [uname=" + uname + ", upassword=" + upassword + "]";
	}		
}




编写连接mysql数据库的代码
package cn.itcast.jdbc;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import com.mysql.jdbc.Connection;
import com.mysql.jdbc.Statement;

public class JdbcTest {

	public static void main(String[]args) throws ClassNotFoundException, SQLException
	{
		//加载驱动
		Class.forName("com.mysql.jdbc.Driver");
		//获得数据库连接
		Connection connection=(Connection) DriverManager.getConnection("jdbc:mysql://localhost:3306/web08?userUnicode=true&characterEncoding=utf-8", "root", "root");
		//通过数据库的里连接操作数据库
		Statement statement=(Statement) connection.createStatement();
		ResultSet rSet=statement.executeQuery("select * from tbl_user");
		while(rSet.next())
		{
			System.out.println("uname:"+rSet.getString("uname")+"   "+"password:"+rSet.getString("upassword"));
		}
		//关闭资源
		rSet.close();
		statement.close();
		connection.close();			
	}
}




输出您想要的结果！