利用Eclipse连接mySQL数据库

create database schoolmanage
 
create table teacherinfo
(   name char(8) null,
code   char(8) null,
sexy char(8) null,
age  char(8) null,
birthay char(8) null,
address char(8) null,
salary char(8) null
)
 
insert into teacherinfo (name,code ,sexy,age,birthday,address,salary) values ('张三' , '2001','男','23','1975-9-1','重庆市','3000');
insert into teacherinfo (name,code ,sexy,age,birthday,address,salary) values ('李四' , '2001','男','23','1975-9-1','重庆市','3000');
insert into teacherinfo (name,code ,sexy,age,birthday,address,salary) values ('王五' , '2001','男','23','1975-9-1','重庆市','3000');
insert into teacherinfo (name,code ,sexy,age,birthday,address,salary) values ('小红' , '2001','女','23','1975-9-1','重庆市','3000');
insert into teacherinfo (name,code ,sexy,age,birthday,address,salary) values ('小黄' , '2001','女','23','1975-9-1','重庆市','3000');

package sql;
import java.sql.*;
 
public class putout {
	private Connection con;
	public static void main(String[] args) {
		putout test = new putout();
		Connection con = test.getConnection();	//定义一个数据连接
		String sql = "select * from teacherinfo";	//数据库查询语句
		test.getStudent(con, sql);
	}
 
	public void getStudent(Connection con,String sql)
	{
		try {
			Statement st = con.createStatement();	//建立会话
			ResultSet rs = st.executeQuery(sql);  //操作数据库
			while(rs.next())
			{
				String name1 = rs.getString(1);
				String code1 = rs.getString(2);
				String sexy1 = rs.getString(3);
				String age1  = rs.getString(4);
				System.out.println("\n姓名："+name1+"\t学号："+code1+"\t性别："+sexy1+"\t年龄："+age1);
			}
			st.close();
			con.close();
		} catch (SQLException e) {
			e.printStackTrace();
		}		
	}
 
	public Connection getConnection()	//连接数据库
	{
		String url1 = "jdbc:mysql://localhost/schoolmanage";	//定义数据库的URL
		String username="root";	//数据库的用户名
		String password = "123456";	//数据库的密码
		try{
			Class.forName("com.mysql.jdbc.Driver");	
			con = DriverManager.getConnection(url1,username,password);	//登录到建立的数据库上
		}catch(Exception e){
			e.printStackTrace();
		}
		return con;
	}
}