ssh项目数据库连接问题

1、新建一个测试数据库连接类

import java.sql.*;
public class test {
	public static void main(String[] args) throws Exception{
		Class.forName("com.mysql.cj.jdbc.Driver");
//		System.out.println(rs);
		String url = "jdbc:mysql://localhost:3306/mystock?";
		String user = "root";
		String password ="123456";
		Connection conn =null;
		conn = DriverManager.getConnection(url, user, password);
		
		String sql = "select * from users";
		Statement sta = conn.createStatement();
		ResultSet rs = sta.executeQuery(sql);
		
		
		System.out.println(rs);
		while(rs.next()){
//			int id = rs.getInt(1);
			String password1 = rs.getString(1);
//			int age = rs.getInt(3);
//			float score = rs.getFloat(4);
			System.out.println(password1);
		}
		sta.close();
		conn.close();
		rs.close();
	}
}

2、数据库驱动包需要与数据库的版本相匹配

a.将数据库驱动jar包添加到文件夹下与java build path 路径中的图书馆中
b.避免同类型jar包的版本冲突，否则会报错，无法运行。

3.spring-basic.xml配置文件数据库相关设置

<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
	<property name="driverClassName" value="com.mysql.jdbc.Driver">
	</property>
	<property name="url" value="jdbc:mysql://localhost:3306/mystock?useUnicode=true&amp;characterEncoding=UTF-8">
	</property>
	<property name="username" value="root"></property>
	<property name="password" value="123456"></property>
</bean>