package com.imooc.db;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;public class DBUtil { private static final String URL="jdbc:mysql://127.0.0.1:3306/imooc"; private static final String USER="root"; private static final String PASSWORD="toor"; public static void main(String[] args) throws ClassNotFoundException, SQLException { //1.加載驅(qū)動(dòng)器 Class.forName("com.mysql.jdbc.Driver"); //2.獲得數(shù)據(jù)庫(kù)的連接 Connection conn=DriverManager.getConnection(URL, USER, PASSWORD); //3.操作數(shù)據(jù)庫(kù) conn.createStatement(); Statement stmt= conn.createStatement(); ResultSet rs=stmt.executeQuery("select user_name,age from imooc_goddess"); while(rs.next()){ System.out.println(rs.getString("user_name"+","+rs.getInt("age"))); } } }控制臺(tái)信息：Exception in thread "main" java.sql.SQLException: Column 'user_name,22' not found. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:998) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:937) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:872) at com.mysql.jdbc.ResultSetImpl.findColumn(ResultSetImpl.java:1073) at com.mysql.jdbc.ResultSetImpl.getString(ResultSetImpl.java:5206) at com.imooc.db.DBUtil.main(DBUtil.java:23)
jdbc連接數(shù)據(jù)庫(kù)
because_ofyou
2016-10-21 04:15:07
