java 连接mysql

pt1：第一步先导入驱动jar包，可以参考菜鸟教程：http://www.runoob.com/java/java-mysql-connect.html





package Db;

import java.sql.*;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.util.List;
import java.sql.Connection;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.Collection;

public class MysqldbTest {
	
	static String url="jdbc:mysql://localhost:3306/betadb";
	static String driver="com.mysql.jdbc.Driver";  
	static String username= "root";
	static String password="123456";
	static Connection conn =null;
	static PreparedStatement pst=null;
	static ResultSet rs=null;
	/*@param: connect database */
	public static List getconnMysqldb(String tbname,String columnname,String columnvalue) {
		ArrayList  list = new ArrayList();
		try {
		Class.forName(driver);
		Connection conn=DriverManager.getConnection(url, username, password);
		String sql="select * from "+tbname +" "+ "where ?=?;";
		pst= conn.prepareStatement(sql);
		pst.setString(1, columnname);
		pst.setString(2,columnvalue);
		rs =pst.executeQuery(sql);
		String jobName=null;
		int pipelineid;
		while(rs.next()) {	
			jobName=rs.getString("jobName");
			pipelineid=rs.getInt("piplineid");
			list.add(rs.getString("jobName"));
			list.add(rs.getInt("pipelineid"));
			rs.close();
			pst.close();
			conn.close();
		}
		}catch(Exception e) {
			e.printStackTrace();
		}	
		return list;	
	}
	// new build 
	public static ArrayList<stuInfo> getAllStus(){
		ArrayList<stuInfo> stulist = new ArrayList<stuInfo>();
		
		String url = "com.mysql.jdbc.Driver"; //加载驱动包
		String connectSql = "jdbc:mysql://127.0.0.1:3306/studentdb"; //链接MySQL数据库
		String sqlUser = "root"; //数据库账号
		String sqlPasswd = "*****"; //你的数据库密码
		
		Connection con = null;
		PreparedStatement psm = null;
		ResultSet rs = null;
		
		
		try {
			//加载驱动包
			Class.forName(url);
			//连接MYSQL
			con = DriverManager.getConnection(connectSql,sqlUser,sqlPasswd);
			//执行MYSQL语句
			psm = con.prepareStatement("select * from stable");
		    rs = psm.executeQuery();
			System.out.println("编号"+"\t"+"姓名"+"\t"+"性别"+"\t"+"年龄");
			while(rs.next()){
				stuInfo s = new stuInfo();
				s.setSno(rs.getInt(1));
				s.setSname(rs.getString(2));
				s.setSex(rs.getString(3));
				s.setAge(rs.getInt(4));
				
				stulist.add(s);	
			}
			
			//关闭数据库连接
			rs.close();
			psm.close();
			con.close();
			
		} catch (Exception e) {
			System.out.println("显示所有数据报错，原因："+e.getMessage());
		}
		
		return stulist;	
	}
}