求jdbc连接mysql的小程序，能有查询修改功能

google，baidu查一下，到处都是~lz练习一下自己的查找能力吧~

import java.sql.Connection;
import java.sql.Date;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;public class ConnectJDBC04 {
public static final String DBDRIVER = "org.gjt.mm.mysql.Driver"; // 数据库驱动常量
public static final String DBURL = "jdbc:mysql://localhost:3306/mldn"; // 数据库地址
public static final String DBUSER = "root"; // 数据库用户名
public static final String DBPASS = "mysqladmin";// 数据库密码 public static void main(String[] args) throws Exception { //抛出异常
Connection conn = null;
Statement stmt = null;
ResultSet result = null;
Class.forName(DBDRIVER);// 加载驱动
conn = DriverManager.getConnection(DBURL, DBUSER, DBPASS);// 建立连接
stmt = conn.createStatement(); // 创建语句
result = stmt
.executeQuery("SELECT pid,name,age,birthday,salary FROM person"); // 提交查询语句返回结果
while (result.next()) { // 查询到内容
int pid = result.getInt("pid"); // 提取字段内容
String name = result.getString("name");// 提取字段内容
int age = result.getInt("age");// 提取字段内容
Date birthday = result.getDate("birthday");// 提取字段内容
Float salary = result.getFloat("salary");// 提取字段内容
System.out.println("pid=" + pid + ",姓名=" + name + ",年龄=" + age
+ ",生日=" + birthday + ",工资=" + salary); // 打印 }
result.close(); // 关闭连接
stmt.close();// 关闭连接
conn.close();// 关闭连接
}}

package Javabeans;
import java.io.*;
import javax.servlet.http.*;
import java.sql.*;
public class DBCon implements HttpSessionBindingListener
{
    //��Sessionʱ�Զ�ִ�д˺��
    public void valueBound(HttpSessionBindingEvent event){}
    //Session��ر�ʱִ�д˺��
    public void valueUnbound(HttpSessionBindingEvent event) {}
    private Connection con = null;
    public DBCon()
    {
        //��b��ݿ�t��
        BulidConnection();
    }
    //��b��ݿ�t�ӵķ��
    private void BulidConnection()
    {
        try
        {
         Class.forName("com.mysql.jdbc.Driver");
            con = DriverManager.getConnection("jdbc:mysql://localhost:3306/cangku","root","long");
        } catch(Exception ex)
        {
            System.out.println(ex.toString());
        }
    }
    public Connection getConnection()
    {
        //��conΪnull��½�bl��
        if(con == null)
            BulidConnection();
        return con;
    }
    public void close()
    {
        try
        {
            //�ر�con
            con.close();
            con = null;
        } catch(SQLException ex){}
    }

}

<%--
    Document   : ChaXun
    Created on : 2009-1-4, 10:09:35
    Author     : rjxy1
--%><%@page contentType="text/html" pageEncoding="UTF-8"%><%@page import="java.sql.*"%>
<%@page language="java"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
   "http://www.w3.org/TR/html4/loose.dtd"><html>
    <head><title>查询货物</title></head>
    <body>
        <center>
            <font size=6 color=blue>
                货物查询
            </font>
        </center>
        <br>
        <center>
            <jsp:useBean id="ConBean" scope="session" class="Javabeans.DBCon"/>
<%
//从Javabeans中取得数据库链接
//建立Statement对象
//建立ResultSet对象，并执行SQL语句
Connection con =ConBean.getConnection();
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("SELECT *  FROM ruku");
%>
            <table bgcolor=red>
                <tr bgcolor=orange>
                    <td><b>货物名称</b></td>
                    <td><b>货物属性</b></td>
                    <td><b>货物数量</b></td>
                    <td><b>添加日期</b></td>
                </tr>
<%
//列出数据库中的数据
while(rs.next())
{
    %>
                <tr bgcolor=white>
                    <td><%=rs.getString("name")%></td>
                    <td><%=rs.getString("shuxing")%></td>
                    <td><%=rs.getString("num")%></td>
                    <td><%=rs.getString("time")%></td>
                </tr>
    <%
}
rs.close();
stmt.close();
//关闭数据库链接
ConBean.close();
%>




            </table>
            <br>
            <td width="55"><a href="Main.jsp">返回</a></td>

        </center>
    </body>
</html>

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=gb2312">
        <title>无标题文档</title>
        <style type="text/css">
            
        </style>

    </head>
    <body>
        <%
            Class.forName("com.mysql.jdbc.Driver"); //载入驱动程序类别            String url = "jdbc:mysql://localhost:3306/cangku";
            String user = "root";
            String pwd = "long";
            Connection con = DriverManager.getConnection(url, user, pwd); //建立数据库链接,studentdata为ODBC数据源名称
            //建立Statement对象            Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
                    ResultSet.CONCUR_READ_ONLY);
        %>


        <center> <h2 class="style1">删除货物信息</h2>
            <br>
            <form name="form1" method="post" action="ChuKu_2.jsp">
                <p><span class="style3">请选择要删除的货物的名称:  </span>
                    <select name="name">
                        <% ResultSet rs = stmt.executeQuery("SELECT * FROM ruku");
            while (rs.next()) {
                String name = rs.getString("name");
                        %>
                        <option value="<%=name%>"><%=name%></option>
                        <%}%>
                        }
                    </select>
                </p>
                <p>
                    <input type="submit"  name="queding" value="确定">
                     
                    <input type="reset" name="chongzhi"  value="重置">
                     
                    <input name="back" type="button" id="back" value="返回" onClick="javascript:history.go(-1)">
                </p>
            </form>
        </center>
    </body>
</html>

插入语句
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.text.SimpleDateFormat;
import java.util.Date;public class MySqlDemo01 {
public static final String DBDRIVER = "org.gjt.mm.mysql.Driver"; // 数据库驱动常量
public static final String DBURL = "jdbc:mysql://localhost:3306/mldn"; // 数据库地址
public static final String DBUSER = "root"; // 数据库用户名
public static final String DBPASS = "mysqladmin";// 数据库密码 public static void main(String[] args) throws Exception {//抛出异常
Connection conn = null;// 声明连接
PreparedStatement stmt = null;// 声明语句
String name = "张三";
int age = 30;
Date date = new SimpleDateFormat("yyyy-MM-dd").parse("1983-02-15");// 格式化日期
float salary = 7000.0f;
String sql = "INSERT INTO person(name,age,birthday,salary)VALUES(?,?,?,?)";// 语句
Class.forName(DBDRIVER);// 加载驱动
conn = DriverManager.getConnection(DBURL, DBUSER, DBPASS);// 建立连接
stmt = conn.prepareStatement(sql); // 加载预编译语句
stmt.setString(1, name); // 加入字段内容
stmt.setInt(2, age);// 加入字段内容
stmt.setDate(3, new java.sql.Date(date.getTime()));// 加入字段内容,按照SQL日期格式化日期
stmt.setFloat(4, salary);// 加入字段内容
stmt.executeUpdate();// 提交
stmt.close();// 关闭连接
conn.close();// 关闭连接 }}

调试易

求jdbc连接mysql的小程序，能有查询修改功能

解决方案 »

求jdbc连接mysql的小程序，能有查询 修改功能

解决方案 »

求jdbc连接mysql的小程序，能有查询修改功能