zzcchunter的专栏

[intrinsic column flags] - PK: primary key (column is part of a pk) - NN: not null (column is nullable) - UQ: unique (column is part of a unique key) - AI: auto increment (the column is auto i

package info.dyndns.split;import info.dyndns.blog.Utility;import java.io.*;import java.sql.*;import javax.servlet.*;import javax.servlet.http.*;public class Split extends HttpServlet { publi

在java程序中一般日期用到的是java.util.Date类而接口 PreparedStatementsetDatevoid setDate(int parameterIndex, Date x) throws SQLException使用运行应用程序的虚拟机的默认时区将指定参数设置为给定 java.sql.Date

package info.dyndns.oszc.Introduce;import java.sql.Connection;import java.sql.ResultSet;import java.sql.Statement;public class SQLInject { public static void read(String name) throws Exception

查询执行ResultSet rs = st.executeQuery(sql);曾 删 改 都执行 st.executeUpdate(sql);注意链接数据库要制定字符集，否则会出现中文乱码问题。最后关闭连接，避免资源浪费。package info.dyndns.oszc.Introduce;import java.sql.*;public class JdbcUtils

package info.dyndns.oszc.Introduce;import java.sql.*;public class BasePlus { public static void main(String[] args) throws Exception { template(); } public static void template() throws Exce

select brand,android_version,phone_model ,count(*) from bugs group by phone_model order by count(*) desc;