传统JDBC对数据库的操作

2019独角兽企业重金招聘Python工程师标准>>>

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class JdbcTest {
	public static void main(String[] args){
		//jdbc连接
		Connection connection = null ;
		//预操作
		PreparedStatement preparedStatement = null ;
		//结果集
		ResultSet resultSet = null ;
		
		try {
			//加载数据库驱动
			Class.forName("com.mysql.jdbc.Driver") ;
			//数据库连接
			connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","") ;
			//输入集
			String sql = "SELECT * FROM USER WHERE ID = ? AND USERNAME=?" ;
			//获取数据库操作对象
			preparedStatement = connection.prepareStatement(sql) ;
			preparedStatement.setString(1,"1") ;
			preparedStatement.setString(2,"11") ;
			//执行数据库操作
			resultSet = preparedStatement.executeQuery();
			
			while(resultSet.next()){
				System.out.println(resultSet.getString("id")+"\t"+resultSet.getString("AGE")) ;
			}
		} catch (Exception e) {
			e.printStackTrace();
		}
		try {
				if(resultSet !=null){
					resultSet.close();
				}
				if(preparedStatement !=null){
					preparedStatement.close();
				}
				if(connection !=null){
					connection.close();
				}
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
	}

记得引mysql-connector-java的jar包呀

转载于:https://my.oschina.net/bugkiller/blog/896745