20.2.3.Setting the Login Timeout设置登录超时时间

最新推荐文章于 2024-07-11 17:35:42 发布

youyigong

最新推荐文章于 2024-07-11 17:35:42 发布

阅读量6.4k

点赞数 1

分类专栏： 20. Database 文章标签： login exception string jdbc import url

20. Database 专栏收录该内容

18 篇文章 0 订阅

订阅专栏

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

import com.mysql.jdbc.ResultSetMetaData;


public class LoginTimeOut {

	public static void main(String[] args) throws Exception{
		Connection con = getConnection();
		con.setAutoCommit(false);
		
		Statement st = con.createStatement();
		ResultSet rs = st.executeQuery("select * from survey");
		outputResultSet(rs);
		
		rs.close();
		st.close();
		con.close();
	}

	private static void outputResultSet(ResultSet rs) throws Exception{
		ResultSetMetaData rsmd = (ResultSetMetaData) rs.getMetaData();
		int numberOfColumns = rsmd.getColumnCount();
		for(int i = 1; i < numberOfColumns; i++){
			String columnName = rsmd.getColumnName(i);
			System.out.println(columnName + "  ");
		}
		System.out.println();
	    System.out.println("----------------------");

	    while(rs.next()){
	    	for(int i = 1; i < numberOfColumns; i ++){
	    		System.out.print(rs.getString(i) + "  ");
	    	}
	    	System.out.println();
	    }
		
		
	}

	private static Connection getConnection() throws Exception{
		Class.forName("com.mysql.jdbc.Driver");
		String url = "jdbc:mysql://localhost/bookshop";
		DriverManager.setLoginTimeout(60);//设置登录超时最长时间为60秒
		return DriverManager.getConnection(url,"root","");
	}

}