import java.sql.*;
public class My{
public static void main(String args[]){
Connection con=null;
try{
Class.forName("org.gjt.mm.mysql.Driver");
con=DriverManager.getConnection("jdbc:mysql://localhost:3306/dusha","root","");
Statement st=con.createStatement();
String sql="select * from book";
ResultSet rs=st.executeQuery(sql);
System.out.println("书本号/t/t书本名/t/t价格");
while(rs.next()){
String cid=rs.getString(1);
String cname=rs.getString(2);
String cprice=rs.getString(3);
System.out.println(cid+"/t/t"+cname+"/t/t"+cprice);
}
rs.close();
st.close();
}catch(Exception e){
e.printStackTrace();
}finally{
try{
con.close();
}catch(Exception e){
e.printStackTrace();
}
}
}
}
java连接mysql
最新推荐文章于 2024-10-17 10:27:13 发布