没装MySQL。
解决方案 »
- PreparedStatement中update语句更新问题。
- 求问JAVA代码中加入MYSQL的INSERT语句的问题
- 在线等!100分,求jsp将EXCEL文档,导入到MYSQL数据库中,并将数据库中的内容导出到本地EXCEL文件!
- Weblogic11部署xfire开发的webservice应用出错
- 配置数据源后,为何无法加载数据库驱动程序?
- 刷新问题?困了很久了
- 多条件Oracle子查询
- 获取当前目录的中文问题,困扰中,请高手帮我看一下啊!!!
- 请问:如何实现在jsp页面中往数据库中添加中文记录!
- JSP如何发布(WEB服务已有TOMCAT)?
- 关于在数据库中查询文本输入框中的信息
- spring问题
package com.asia.jdbc;import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;public class MySqlJdBc { public static void main(String[] args) {
Connection con = null;
PreparedStatement pstm = null;
try {
Class.forName("org.gjt.mm.mysql.Driver");
con = DriverManager.getConnection("jdbc:mysql://localhost:3306/tesql", "root", "");
String sql = "select username ,email from user";
pstm = con.prepareStatement(sql);
pstm.executeQuery();
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}finally{
try {
if(pstm!=null)
pstm.close();
if(con!=null)
con.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
这个Driver有点年头了。估计好多都不支持了。
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;public class DBConn {
private static String url = "jdbc:mysql://localhost:3306/test";
private static String user = "root";
private static String password = "123"; public Connection con=null;
public Statement stmt=null;
public ResultSet rs=null;
public DBConn() {
try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
} catch (InstantiationException e) {
System.out.println(e.getMessage());
e.printStackTrace();
} catch (IllegalAccessException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public Connection getConn(String url,String username,String password){
try {
con= DriverManager.getConnection(url,username,password);
} catch (SQLException e) {
System.out.println("数据库连接失败 "+e.getMessage());
}
return con;
}
public Connection getConn(){
try {
con= DriverManager.getConnection(url,user,password);
} catch (SQLException e) {
System.out.println("数据库连接失败 "+e.getMessage());
}
return con;
}
public static void free(ResultSet rs, Statement st, Connection conn) {
try {
if (rs != null)
rs.close();
} catch (SQLException e) {
} finally {
try {
if (st != null)
st.close();
} catch (SQLException e) {
e.printStackTrace();
} finally {
try {
if (conn != null)
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
public void showUser(){
}
public static void main(String[] args) {
DBConn dbcon=new DBConn();
try {
dbcon.getConn().createStatement();
String sql="select * from user";
rs=stmt.executeQuery(sql);
while (rs.next()) {
rs.getInt(1);
rs.getString("name");
rs.getString("sex");
System.out.println(rs.getObject(1) + "\t" + rs.getObject(2)+"\t" + rs.getObject(3));
}
} catch (SQLException e) {
System.out.println("建立sql语句失败 "+e.getMessage());
e.printStackTrace();
}finally{
free(rs,stmt,con);
}
}}