- Java code
package net.icefish.bean;import java.sql.*;public class Conn{ //public Connection conn=null; public static Connection Connection(){ //public conn(){ Connection conn=null; try{// request.setCharacterEncoding("gb2312"); Class.forName("com.mysql.jdbc.Driver").newInstance(); } catch(Exception e){ System.out.print(e.toString()); } try{ String url="jdbc:mysql://127.0.0.1:3306/icefish?useUnicode=true&characterEncoding=gb2312"; //数据库名统一为icefish,表名与字段名参照概要设计文档 String user="root"; //设置用户名 String password="root"; //设置密码 conn=DriverManager.getConnection(url,user,password); } catch(SQLException e){ System.out.print(e.toString()); } return conn; } // public void close(){// try{// conn.close();// }// catch(SQLException e){// System.out.print(e.toString()); // }// }}
这是Conn类
- Java code
package net.icefish.bean;import java.sql.*;import net.icefish.bean.Conn;public class test{ public static void main(String[] args){ try{ Connection icefish=Conn.connection(); Statement stmt=icefish.createStatement(); ResultSet rs=stmt.executeQuery("select * from icefish_admin"); while(rs.next()) System.out.print(rs.getString(1)+" "); icefish.close(); }catch(SQLException e){ System.out.print(e.toString()); } }}
这是我的测试类
然后就出错了
import net.icefish.bean.Conn;
^
符号: 类 Conn
位置: 程序包 net.icefish.bean
test.java:9: 错误: 找不到符号
Connection icefish=Conn.connection();
^
符号: 变量 Conn
位置: 类 test
2 个错误
------解决方案--------------------
Connection icefish=Conn.connection();
=》
Connection icefish=Conn.Connection();