tomcat6+mysqlÁ¬½Ó³ØµÄ¼òµ¥ÊµÏÖ(Ç××ÔÊÔÑéͨ¹ý)
ÔÚÍøÉÏÕÒÁ˺ܾã¬ÎÄÕ¶¼ÊÇÄ㳡¢ÎÒ³Äã¡£¿´À´¿´È¥¶¼Ò»ÑùµÄ£¬googleÍùºó·NÒ³ ½øÈ¥Ò»¿´¶¼ÊÇÒ»ÑùµÄ¡£ÓôÃÆÖÁ¼«¡£ ÓÚÉÏÊÇCSDNÂÛ̳ÇóÖú£¬»¹ÊÇjava\web̳×ÓÀïµÄÅóÓÑÈÈÇéЩ£¬ÖÕÓÚËãÊǸãºÃÁË£¬×Ô¼ºÔÙÊÔÁËÏ£¬°ÑÐĵ÷¢³öÀ´´ó¼ÒÖ¸µãÖ¸µã¡£ 1¡¢mysql-connector-java-5.0.8-bin.jarÎļþ£¬Ò²¾ÍÊÇmysqlÇý¶¯°ü¡£×¢Ò⣺Ҫ·Åµ½tomcat6/libĿ¼Ï¡£·Åµ½web-inf/libϲ»ÐУ¬²»ÖªµÀΪʲô£¬ÎÒ»áÔÙÊÔÊÔ¡£ 2¡¢ÐÞ¸Ätomcat6/conf/context.xmlÎļþ£¬ÒÔ<context>±êǩ֮¼ä¼ÓÉÏ 1: <Resource name="jdbc/mysql"
2: auth="Container"
3: type="javax.sql.DataSource"
4: driverClassName="com.mysql.jdbc.Driver"
5: url="jdbc:mysql://localhost:3306/test"
6: username="root"
7: password="root"
8: maxActive="100"
9: maxIdle="30"
10: maxWait="5000" />
Òâ˼Ӧ¸ÃÒ»¿´¾ÍÄÜÃ÷°×£¬¾Í²»½âÊÍÁË¡£
3¡¢²âÊÔÒ³Ãæ
1: <!doctype html public "-//w3c//dtd html 4.0 transtional//en"
2: "help://www.w3.org/TR/REC-html40/strict.dtd">
3: <%@ page import="java.sql.*,javax.sql.*,javax.naming.*" session="false" %>
4: <html>
5: <head>
6: <meta http-equive="Content-Type" content="text/html"; charset="gbk">
7: <title></title>
8: <body>
9:
10: <%
11: out.println("¿ªÊ¼²âÊÔ!");
12: DataSource ds;
13: InitialContext ctx;
14: try{
15: ctx=new InitialContext();
16: ds=(DataSource)ctx.lookup("java:comp/env/jdbc/mysql");
17: Connection con=ds.getConnection();
18: Statement stmt=con.createStatement();
19: String sql="select * from person";
20: ResultSet rs=stmt.executeQuery(sql);
21: while(rs.next()){
22: out.println(rs.getString(2));
23: }
24: out.println("²âÊԳɹ¦£¡");
25: }
26: catch(Exception e){
27: out.println(e.toString());
28: }
29:
30: %>
31: </body>
32:
Ïà¹ØÎĵµ£º
ÐÞ¸Ä /etc/mysql/my.cnf Îļþ£¬
ÔÚ £Ûclient£Ý ϼÓÈë default-character-set=utf8,
ÔÚ [mysqld] ϼÓÈë default-character-set=utf8,
ÔòÔÚviÀï¿ÉÒÔÕýÈ·µÄÏÔʾÖÐÎÄÁË£¨Ç°ÌáÊÇviҲʹÓÃutf8£©¡£
²»¹ýÔÚ²éѯµÄʱºò£¬½á¹ûÀïµÄÖÐÎÄÈ´»áÏÔʾ³É "?"£¬Õâ¸öÎÊÌâ±È½Ï¼òµ¥µÄ·½·¨Óм¸ÖÖ£¬·Ö±ðÊÇ£º
1.ÔÚ´´½¨Ê ......
ÔËÐгÌÐò¿ÉÄܻᱨ´í£ºCan’t connect to local MySQL Server through socket ‘/tmp/mysql.sock’
Õâ¸ö´íÎóµÄÌáʾÊÇ˵£¬²»ÄÜͨ¹ý’/tmp/mysql.sock’Á¬½Óµ½·þÎñÆ÷¡£Mysql.sockÊÇ´´½¨Óëmysqld·þÎñÆ÷Ïà¹ØµÄMySQLͨÐŶ˵ãËùʹÓõÄÌ×½Ó×Ö¡£¶øPHP±ê×¼ÅäÖÃÕýÊÇͨ¹ý’/tmp/mysql.sock’À´Á¬½Ó ......
½ñÌìºÍһλ¼Ü¹¹Ê¦ÁÄÁËһЩÎÊÌ⣬ºÜżȻµÄ˵³öÁËÒ»¸öÊÂÇ飬ÎұȽϸÐÐËȤÓÚÊǼǼһÏ£º
1£ºÎÒÃǶ¼ÖªµÀmysqlÏ µÄINNODBºÍMYISAMÁ½ÖÖÒýÇæ£¬ÆäÖÐINNODB¾ßÓÐÊÂÎï¹ÜÀí¡£ËùÒÔINNODBϲÙ×÷ºÍMYISAMϲÙ×÷£¬µ¥´¿µÄ´Ó²åÈëÊý¾Ý¿âÉÏ˵£¬INNDODBµÄ¿É¿¿£¬²éѯÉÏ˵MYISAMµÄÒª¿ì¡£
2£º»ùÓÚÉÏÃæµÄÌØÐÔ£¬ÒÔ¼°MYSQLjuyouµÄÖ÷´Ó»úÖÆ£¬ÎÒÃÇ¿ÉÒ ......
Ò»¡¢Êý×ÖÀàÐÍ
ËùνµÄ“Êý×ÖÀà”£¬¾ÍÊÇÖ¸ DECIMAL ºÍ
NUMERIC£¬ËüÃÇÊÇͬһÖÖÀàÐÍ¡£ËüÑϸñµÄ˵²»ÊÇÒ»ÖÖÊý×ÖÀàÐÍ£¬ÒòΪËûÃÇʵ¼ÊÉÏÊǽ«Êý×ÖÒÔ×Ö·û´®ÐÎʽ±£´æµÄ£»ËûµÄÖµµÄÿһ루°üÀ¨Ð¡Êýµã£©Õ¼Ò»¸ö×ֽڵĴ洢¿Õ¼ä£¬Òò´ËÕâÖÖÀàÐͺķѿռä±È½Ï´ó¡£µ«ÊÇËüµÄÒ»¸öÍ»³öµÄÓŵãÊÇСÊýµÄλÊý¹Ì¶¨£¬ÔÚÔËËãÖв»»á“ʧ ......
import java.io.File;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import jxl.*;
public class ImportExcel {
public static void main(String[] args) {
File importExcel = new File("D:\\test\\test.xls");
try {
// Êý¾Ý¿âÁ¬½Ó
Class.forNa ......