我想实现java连接数据库并且可以执行sql代码,怎么操作呢? 我想实现java连接数据库并且可以执行sql代码,怎么操作呢? 网上的教程就一些代码,新手看不懂的 有没有教程 或是好心的大哥 写的详细一点 我要运行 select * from good where id >30 这句代码 再java怎么实现呢? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 import java.sql.*;public class TestMySQL { public static void main(String[] args) { String dbDriver="com.mysql.jdbc.Driver"; //jdbc String dbUrl="jdbc:mysql://localhost:3306/notebase"; //notebase为数据库表名 String dbUser="root"; //数据库管理员用户名 String dbPassword="r1234"; //用户密码 Connection conn=null; PreparedStatement ptmt=null; ResultSet rs=null; String sql=null; try { sql="SELECT id,title,author,content FROM note"; //这是要执行的sql语句 Class.forName(dbDriver); //加载jdbc conn=DriverManager.getConnection(dbUrl,dbUser,dbPassword); //连接数据库 ptmt=conn.prepareStatement(sql); //将sql发送到数据库 rs=ptmt.executeQuery(); //执行sql while (rs.next()) //获取数据库中查询的内容并打印输出 { int id=rs.getInt(1); String title=rs.getString(2); String author=rs.getString(3); String content=rs.getString(4); System.out.print(id+" "+title+" "+author+" "+content); } rs.close(); //关闭RS ptmt.close(); //关闭prmt conn.close(); //关闭连接 } catch (Exception e) { } }} package org;import java.sql.*;public class DBConnection { static Connection conn = MySql.getConn(); /** * @param args */ public static void main(String[] args) { getData(); } static void getData(){ Statement sm = null; try { sm = conn.createStatement(); ResultSet rs = sm.executeQuery("select * from zhao"); while(rs.next()){ System.out.println("id:"+rs.getInt(1)); System.out.println("name:"+rs.getString(2)); } } catch (SQLException e) { e.printStackTrace(); }finally{ if(sm!=null){ try { sm.close(); conn.close(); } catch (SQLException e) { e.printStackTrace(); } } } }}class MySql { static Connection conn = null; static{ try { Class.forName("com.mysql.jdbc.Driver"); String strDiver = "jdbc:mysql://127.0.0.1:3306/bookDB?useUnicode=true&characterEncoding=GBK"; conn = DriverManager.getConnection(strDiver,"root","1234"); } catch (ClassNotFoundException e) { e.printStackTrace(); } catch(SQLException e){ e.printStackTrace(); } } public static Connection getConn() { return conn; }} import java.sql.*;public class dbcon{ String user="sa"; String password="sa"; String driverName="sun.jdbc.odbc.JdbcOdbcDriver"; String connectURL="jdbc:odbc:news"; Connection conn=null; Statement stmt=null; ResultSet rs=null; public dbcon() { try{ Class.forName(driverName); conn=DriverManager.getConnection(connectURL,user,password); conn.setAutoCommit(true); stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY); } catch(Exception e) { System.out.println("数据库连接错误"+e.getMessage()); } } public ResultSet executeQuery(String sql) { try{ rs=stmt.executeQuery(sql); } catch(SQLException ex) { System.out.println("数据库查询错误"+ex.getMessage()); } return rs; } public int executeUpdate(String sql) { try{ int i=stmt.executeUpdate(sql); return i; } catch(SQLException ex) { System.out.println("执行更新错误:"+ex.getMessage()); return -1; } } public Connection getcon() { return conn; }} java 界面问题 java服务器端程序是如何执行的? javamail收新浪邮件问题 请问:return type for the method is missing 是什么错误或 关于SWT中的Text组件显示String的问题 一个关于布局的问题 www.go2map.com里下载地图时出现的“正在查询请稍候”的图标是怎么出来的? FocusListener问题: visual cafe 和forte for java 可以在那儿下载呀? 请 请问??? FileWriter的疑惑 关于java包问题
import java.sql.*;
public class TestMySQL { public static void main(String[] args) {
String dbDriver="com.mysql.jdbc.Driver"; //jdbc
String dbUrl="jdbc:mysql://localhost:3306/notebase"; //notebase为数据库表名
String dbUser="root"; //数据库管理员用户名
String dbPassword="r1234"; //用户密码
Connection conn=null;
PreparedStatement ptmt=null;
ResultSet rs=null;
String sql=null;
try
{
sql="SELECT id,title,author,content FROM note"; //这是要执行的sql语句
Class.forName(dbDriver); //加载jdbc
conn=DriverManager.getConnection(dbUrl,dbUser,dbPassword); //连接数据库
ptmt=conn.prepareStatement(sql); //将sql发送到数据库
rs=ptmt.executeQuery(); //执行sql
while (rs.next()) //获取数据库中查询的内容并打印输出
{
int id=rs.getInt(1);
String title=rs.getString(2);
String author=rs.getString(3);
String content=rs.getString(4);
System.out.print(id+" "+title+" "+author+" "+content);
}
rs.close(); //关闭RS
ptmt.close(); //关闭prmt
conn.close(); //关闭连接
} catch (Exception e) {
}
}
}
package org;
import java.sql.*;public class DBConnection {
static Connection conn = MySql.getConn();
/**
* @param args
*/
public static void main(String[] args) {
getData();
}
static void getData(){
Statement sm = null;
try {
sm = conn.createStatement();
ResultSet rs = sm.executeQuery("select * from zhao");
while(rs.next()){
System.out.println("id:"+rs.getInt(1));
System.out.println("name:"+rs.getString(2));
}
} catch (SQLException e) {
e.printStackTrace();
}finally{
if(sm!=null){
try {
sm.close();
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
}
class MySql {
static Connection conn = null;
static{
try {
Class.forName("com.mysql.jdbc.Driver");
String strDiver = "jdbc:mysql://127.0.0.1:3306/bookDB?useUnicode=true&characterEncoding=GBK";
conn = DriverManager.getConnection(strDiver,"root","1234");
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch(SQLException e){
e.printStackTrace();
}
}
public static Connection getConn() {
return conn;
}
}
import java.sql.*;
public class dbcon
{
String user="sa";
String password="sa";
String driverName="sun.jdbc.odbc.JdbcOdbcDriver";
String connectURL="jdbc:odbc:news";
Connection conn=null;
Statement stmt=null;
ResultSet rs=null;
public dbcon()
{ try{
Class.forName(driverName);
conn=DriverManager.getConnection(connectURL,user,password);
conn.setAutoCommit(true);
stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
}
catch(Exception e)
{
System.out.println("数据库连接错误"+e.getMessage());
}
}
public ResultSet executeQuery(String sql)
{
try{
rs=stmt.executeQuery(sql);
}
catch(SQLException ex)
{
System.out.println("数据库查询错误"+ex.getMessage());
}
return rs;
}
public int executeUpdate(String sql)
{
try{
int i=stmt.executeUpdate(sql);
return i;
}
catch(SQLException ex)
{
System.out.println("执行更新错误:"+ex.getMessage());
return -1;
}
}
public Connection getcon()
{
return conn;
}
}